Min & Max help

[George B.]

Hello,
The best way to describe what I need help on is below. Column's A & B I
have now.
I need your help creating 2 formulas, 1 formula entered into cell C1 then
filled down, 1 formula entered into cell D1 and filled down also.
Cell C1 formula would count the number of rows from first "minimum" to the
next "max". Then from that "max" to next "minimum".
Cell D1 formula 'filled down' in example below would compute the % increase
or % decrease from minimum to max and max to minimum.


have have need need
A B C D
1 40 minimum
2 45
3 52
4 56 max 3 A1 to A4 % increase <----what I
need
5 49
6 44 minimum 2 A4 to A6 % decrease <----what I need
7 45
8 47
9 48
10 51 max 4 A6 to A10 % increase <---what I
need

Thanks to anyone who can help!
George.

 

[Frank Kabel]

Hi
in C2 enter:
=IF(B2<>"",ROW()-LOOKUP(2,1/($C$1:$C1<>""),ROW($C$1:$C1)),"")
and copy this down

in D2 enter
=IF(B2<>"",A2/OFFSET(A2,-C2,0)-1,"")
and format this cell as percentage. Copy down