Duke Carey wrote:
I think you can find the row number of the first occurrence of the most
recent dates for ACME by using this formula, entered with Ctrl-Shift-Enter

=MATCH("Acme"&MAX(IF(A1:A21="Acme",C1:C21)),A1:A21 &C1:C21,0)

where A1:A21 contains the customer names and C1:C21 contains the dates

Does that get you what you want?


Duke,

{=MATCH("Ford"&MAX(IF(A3:A100="Ford",E3:E100)),A3: A100&E3:E100,0)}

successfully returns the row number on the page which contains the
latest data.
Thank you.
2 questions:
How do I obtain the price in this row from a cell 5 columns to the
right?
and
How do drop down one (or more) row(s) to obtain the same information
from an additional price break?

many thanks.
Pierre