May be dumb but...

S

Shawn Shuler

I have two columns, one with labels for the inormation in the second,
numerical data, column.

A 9
B 8
C 10

I want to determine the minimum value of the second column (8) and place it
in a cell. I also need the label for that minimum value (B) to go into
another column.

I can get the minimum, no problem. How, though, do I get a cell to then
pick off the label? If I could combine some functions I could do it but
that doesn't work in Excel.
 
Z

Zack Barresse

Hi there,

Something like this ..

=MIN(B1:B10)

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

This is assuming your range of course (A1:B10); change to suit.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show other cell if blank 5
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Min function with a variable range 2
help on a formula (match and etc..) 1
Locate text in range (multiple occurrences) and report other cell insame column? 10
Figuring out a lengthy formula. Probably quite simple... 3
Sum by range of time 4
Excel Concatenate with line breaks but ignore blank cells 3

Top