Welcome Guest
You last visited December 10, 2016, 7:35 am
All times shown are
Eastern Time (GMT-5:00)

# Excel... getting numbers to go to smallest to largest

Topic closed. 4 replies. Last post 2 years ago by GASMETERGUY.

 Page 1 of 1
Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: April 12, 2015, 2:04 pm - IP Logged

How does  one sort from smallest to largest in excel?  Now that I got my 3 columns into one... i would like to have them go from 436 to 346 or 912 to 129  smallest to largest #

Hope someone can help... appreciate it greatly

We are all Lucky... just some of us don't realize it!

New Jersey
United States
Member #17843
June 28, 2005
49813 Posts
Offline
 Posted: April 12, 2015, 2:41 pm - IP Logged

How does  one sort from smallest to largest in excel?  Now that I got my 3 columns into one... i would like to have them go from 436 to 346 or 912 to 129  smallest to largest #

Hope someone can help... appreciate it greatly

Cell D2: =SMALL(\$A2:\$C2,1)*100+SMALL(\$A2:\$C2,2)*10+SMALL(\$A2:\$C2,3)

A mind once stretched by a new idea never returns to its original dimensions!

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: April 12, 2015, 2:42 pm - IP Logged

Cell D2: =SMALL(\$A2:\$C2,1)*100+SMALL(\$A2:\$C2,2)*10+SMALL(\$A2:\$C2,3)

You are Awesome...thank you so much!

ok i can't make this work.... say I got 847 in cell cj15.... how do I put formula in to make it change it to 478?

We are all Lucky... just some of us don't realize it!

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: April 12, 2015, 3:18 pm - IP Logged

ok got it... had to go back to original single digit in each column not all 3 in one column

We are all Lucky... just some of us don't realize it!

NASHVILLE, TENN
United States
Member #33372
February 20, 2006
1044 Posts
Offline
 Posted: April 12, 2015, 7:58 pm - IP Logged

ok got it... had to go back to original single digit in each column not all 3 in one column

Always put single digits in their own column.  This way you can manipulate the data any which way.

 Page 1 of 1