Large function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show me your highest mileage HDD? 0
Excel Lookup 1
Excel PRICE function: How does it compute Issue Date of the Security 5
need some beginner help with LOOKUP functions 0
Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
Find Last entry for Col in Multi column array using cell from another array. 1
Find last date of sold stock and sold price. 2
Percentage Increase 13

Back
Top