Finding the lowest value

L

Lynn

Here's a good one. I have 2 columns - Column A is
products; column B is quantity. I need to find out which
product sold the least, and which produst sold the most.
Example -

Column A Column B
Apples 10
Oranges 15
Peaches 12
Plums 7

I can easily do a MIN fuction to find that 7 is the lowest
number, but I actually want something that tells me that
this refers to Plums. Same for Max.
 
G

Gerry Kuta

Try this;
=INDEX(A1:An,(MATCH(Bn+1,B1:Bn)) n= your last row
for the name in Column A.
HTH
 
Top