Thread
:
Minimum Value & Cell Cross Referencing
View Single Post
#
5
Johnny
Junior Member
Posts: 2
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!
Reply With Quote
Johnny
View Public Profile
Send a private message to Johnny
Find all posts by Johnny