Have you looked at the Auto Filter facility? If your columns have headers,
click in a cell below the headers and then go to Data, Auto filter on the
menubar. Click the filter arrows that should appear next to the headers and
use the options there-in.

Rob

"Eric" wrote in message
...
There are two lists under column A and B,
Under column A, there is a list of date and under column B, there is a
list
of price, and I would like to search for the maximum value under column B
and
return the date under column A for this maximum value.
Does anyone have any suggestion on how to do it?
Thank for any suggestions
Eric