Thread: Finding Maximum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger H.
 
Posts: n/a
Default 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.