View Single Post
  #5   Report Post  
Johnny Johnny is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Biff
Hi!

=INDEX(A2:A52,MATCH(MIN(D2:D52),D2:D52,0))

Is there a possibility of duplicate minimums?

The above formula will always find the first instance.

Biff


--
Johnny[/i][/color]
Superb. My thanks to you both!