compare 2 columns and select the lowest

D

Delya

Hi
I have simple question
I have 2 coumns A and B
A1 is text and B1 is numbers and so on.. depending of B columns numbers , i
want colums C to show alway lowest numbers on top, but also text
like if A1,B1 is Mike 29
then A2,B2 is Josh 34, then column C shows Mike 29 but on top, not as a
secon row..
 
D

Dave Peterson

Couldn't you just sort by column B in ascending order and leave the data right
where it is?

If that's not ok, how about an alternative?

I'd add a new column C.

Then use a formula like this in C1:

=text(a1,"000")&"-"&b1
and drag down.

You'd see:

029-Mike

Then I'd sort the entire range (A:C) by column C.

ps. Since this formula in column C returns text, you'll have to use the format
in the =text() portion to make sure that all the digits are showing -- use the
worse case scenario.
 

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

Top