Jive,

I think a pivot table would work nicely for this.

Put B in the Row area of the pivot table.
Put A in the Data area, then set the properties to find the minimum.

Look up pivot tables in XL's Help to learn how to use them. If you still
need help, write back for detailed instructions.

HTH,

Conan




"Jive" wrote in message
...
I have a colum of values, from which i need to find the minimum. However i
only want it to refer to those which have a specifc value in the adjacent
column. i.e.

A B
1 3 1
2 2 1
3 5 2
4 6 2
5 4 3
6 1 1

Minimum for "B=1" 1
Minimum for "B=2" 5
Minimum for "B=3" 4

Thanks in advance