| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX & MATCH functions
I have date info in cells A1:A20 and scores(golf scores) in cells B1:B20. The
same score may appear more than once in cells B1:B20. I am trying to find the dates on which the lowest scores occur. I can find the first occurence of the low score by using this formula in cell c1: =INDEX(A1:A20,MATCH(MIN(B1:B20),B1:B20,-1)*0) What would I put in cell C2 to find the next occurence (date) of the low score? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with using match and index functions | Excel Discussion (Misc queries) | |||
| Index and Match Functions | Excel Worksheet Functions | |||
| Nesting Index and Match Functions | Excel Worksheet Functions | |||
| Help Please - Match & Index Functions (I hope)! | Excel Discussion (Misc queries) | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
Threaded Mode
