Finding Maximum
Hello. Thanks for considering my post.
I have several thousand numbers in column A.In column B, I am using the
Match function to locate the next occurrence of each number in A.No
problem.What I need now is some advanced formula manipulations to find the
Maximum of the series for *each* number that is returned by Match.I want
each Maximum in an individual cell.
In column C, I will simply put a series of numbers starting with 1 and
ending with 333.In column D, I want the maximum returned by Match in B for
*each* number in C.
Thank you.
|