View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default 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