Minimum U/Cost for multiple items...

[muralidaran]

Hi
In the sample file attached i have 2 columns 1 as Items and anther as U/cost i just want to find out the minimum cost U/Price.
please help...
Thanks..

[Tony Valko]

Try this array formula** entered in H2 and copied down:

=MIN(IF(A$2:A$11=G2,B$2:B$11))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[muralidaran]

Thanks a lot it works.......

[Tony Valko]

You're welcome. Thanks for the feedback!