Excel... getting numbers to go to smallest to largestPrev TopicNext Topic

• Rakster

  

  Saskatchewan
  Canada
  Member #19,991
  August 9, 2005
  2,960 Posts
  Offline
  Apr 12, 2015, 2:04 pm

  ▲▼

  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!
  
  
• Raven62

  

  25

  New Jersey
  United States
  Member #17,842
  June 28, 2005
  180,983 Posts
  Offline
  Apr 12, 2015, 2:41 pm

  ▲▼
  In response to Rakster

  Quote: Originally posted by Rakster on Apr 12, 2015

  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!
  
  Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.
  
  Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.
  
  The best way to learn is to never stop being an Experiential Student!
• Rakster

  

  Saskatchewan
  Canada
  Member #19,991
  August 9, 2005
  2,960 Posts
  Offline
  Apr 12, 2015, 2:42 pm

  ▲▼
  In response to Raven62

  Quote: Originally posted by Raven62 on Apr 12, 2015

  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!
  
  
• Rakster

  

  Saskatchewan
  Canada
  Member #19,991
  August 9, 2005
  2,960 Posts
  Offline
  Apr 12, 2015, 3:18 pm

  ▲▼

  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!
  
  
• GASMETERGUY

  

  NASHVILLE, TENN
  United States
  Member #33,371
  February 20, 2006
  1,044 Posts
  Offline
  Apr 12, 2015, 7:58 pm

  ▲▼
  In response to Rakster

  Quote: Originally posted by Rakster on Apr 12, 2015

  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.