Need to get a minimum value

[adaws]

Hi,

I need help with a function, that will get me the minimum value for a range of same names.

Ex: In the attached file, i need a function in column C which will give me minimum value for each name in value A.

So for the name Dawson, the result should be 6 and for the name Sarfaraz the result should be 5.

Thanks,
Abhi

[MarvinP]

Hi Abhi,

This is a perfect place for a Pivot Table and using Minimum instead of totals in the value field. See the attached for the example.

[adaws]

Hi Marvin,

Thank you for the suggestion, however, i am looking for a function which could give me the result but not from a Pivot table.

Regards,
Dawson

[alansidman]

See attached.

[Richard Buttrey]

Hi,

As an array formula (entered with Ctrl-Shift-Enter) in C2 copied down

Please Login or Register  to view this content.

[martindwilson]

=MIN(IF($A$2:$A$12=c1,$B$2:$B$12)) array entered with ctrl+shift+enter
where
c1 contains dawson

[newdoverman]

Enter this in C2 and copy down. The min value for each name will be repeated beside the name. Enter with Ctrl + Shift +Enter

Please Login or Register  to view this content.