software

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.
Hazarding a guess that this might be one way ..

Assuming data in col A is within A1:A1000
and the numbers in col C are in C1:C333

Put in D1, array-enter (press CTRL SHIFT ENTER):
=MAX(IF($B$1:$B$1000=C1,$A$1:$A$1000))
Copy D1 down to D333
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Roger H.quot; gt; wrote in message
...
gt; Hello. Thanks for considering my post.
gt;
gt; I have several thousand numbers in column A.In column B, I am using the
gt; Match function to locate the next occurrence of each number in A.No
gt; problem.What I need now is some advanced formula manipulations to find the
gt; Maximum of the series for *each* number that is returned by Match.I want
gt; each Maximum in an individual cell.
gt; In column C, I will simply put a series of numbers starting with 1 and
gt; ending with 333.In column D, I want the maximum returned by Match in B for
gt; *each* number in C.
gt; Thank you.
gt;
gt;