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
http://savefile.com/projects/236895
--
"Roger H." wrote in message
...
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.