Large function

P

Peter B

I am having a list of dates and prices. I sort the prices in this list by
using the Large function. But i would also like to get the date for that
price. I have thought about using Lookup, but since i have more than one day
with equal price it does not work. Anyone have any suggestions?

05.03.2005 237,3029
05.03.2005 221,2681
05.03.2005 219,5479
05.03.2005 218,0591
05.03.2005 219,1757
05.03.2005 216,9124
 
B

Bernard Liengme

With dates in A:A and values in B:B, use
=INDEX(A1:A6,MATCH(LARGE(B1:B6,1),B1:B6,0))
to get date corresponding to first largest value
best wishes
 
Top