Hi

Here is a problem that has kept me scratching my head for some time.
I have two dynamically changing columns of data in columns A and B.
For each column, the rows are incremented using variable MEASUREMENT
for A and B in vba. There are 20 machines whose numbers appear in A
and their corresponding measurements appear in B. The columns contain
many measurements for each machine.

I would like to accomplish the following example in vba using the
variable MEASUREMENT.

Example: For machine # 12 in column A, (range = A1:A(MEASUREMENT)),
find the MAX of its corresponding measurements in column B (range =
B1:B(MEASUREMENT)) and save it in cell C1.

I would like to accomplish this without using volatile functions like
OFFSET and COUNT. Any help is appreciated as I am running out of
ideas.

Thanks

JP

Using Windows XP, Excel 2003