Welcome Guest
Log In | Register )
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
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
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!

    Raven62's avatar - binary
    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!

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      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!

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        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!

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