Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Large function
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 -- Peter B Norway |
#2
|
|||
|
|||
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Peter B" wrote in message ... 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 -- Peter B Norway |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Help on Large Function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |