I have an application that dynamically downloads a date and a value.
I want to get a local high or low point , followed by the next high or low point .
=min/max(bn:bn) (where n is the cell number) won't work because the there may be
multiple - or no - high or low points within the range.
In effect , I am searching to the next high/low point , then using that as the starting point for
the next search.
John Yard
Like this?
min C3 and down: =IF(B3=MAX(B2:B4), "max", IF(B3=MIN(B2:B4), "min", "")) max min max min max min max min max min
Last edited by shg; 11-20-2013 at 03:24 PM.
Entia non sunt multiplicanda sine necessitate
Not quite. The data set occilates between pairs of high and low values.
Finding a high/low pair , it resets the search. In effect , B2:b3 must be variables,
subject to reset.
Perhaps
C3: =IF(B3>C2, B3, C2) min D3: =IF($B3 < D2, $B3, D2) max min E4: =IF(C4>C3,"max",IF(D4<D3,"min","")) min min min
Thx. I think I have enough here to make it work. JYard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
JohnYard 
Register To Reply
Bookmarks