Finding the lowest value

[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.

 

[Chip Pearson]

Lynn,

Try something like the following:

=INDEX(A1:A10,MATCH(MIN(B1:B10),B1:B10,0))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Gerry Kuta]

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

 

[lynn]

Works great. Thanks !!

-----Original Message-----
Lynn,

Try something like the following:

=INDEX(A1:A10,MATCH(MIN(B1:B10),B1:B10,0))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)






.