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

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

Try something like:

=INDEX(A1:A100,MATCH(MAX(B1:B100),B1:B100,0))

Adjust the ranges to suit, and format the cell as a date.

Hope this helps.

Pete

On May 3, 10:26 am, Eric wrote:
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

Thank everyone very much for suggestions
Eric

"Pete_UK" wrote:

Try something like:

=INDEX(A1:A100,MATCH(MAX(B1:B100),B1:B100,0))

Adjust the ranges to suit, and format the cell as a date.

Hope this helps.

Pete

On May 3, 10:26 am, Eric wrote:
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