=min(if(

C

ceemo

Im after a formula to put in min column that will look up the uniqu
column in the name column and present the minimummatching number

Name No. Unique Min
Jen 4 Jen ?
Jon 6 Jon ?
Ray 7 Ray ?
For 8 For ?
Jick 4 Jick ?
Yen 5 Yen ?
Ray 4 bob ?
bob 12 hick ?
for 5 jen ?
hick 45
jen
 
R

RagDyer

Is it a typo that you have 2 "jen" in the unique column?

Anyway try this *array* formula in D2, and copy down as needed:

=MIN(IF($A$2:$A$12=C2,$B$2:$B$12))

--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top