Welcome Guest
Log In | Register )
You last visited January 18, 2017, 9:04 am
All times shown are
Eastern Time (GMT-5:00)

Need Excel 07 Macro or formular to sort numbers

Topic closed. 3 replies. Last post 7 years ago by Raven62.

Page 1 of 1
PrintE-mailLink
Avatar
Iron Station, NC
United States
Member #74828
May 21, 2009
69 Posts
Offline
Posted: October 3, 2009, 12:11 pm - IP Logged

I’ve downloaded the NC Powerball for all games, only problem is, they are not sorted from left to right.I need a formula or macro that will sort from small to large from left to right the five white balls.  I can do one row at a time but there are 348 rows and it would take me forever. I have cut the date and Power Ball data out of my worksheet for now. The numbers start in Cell B2 thru F2 then down for 348 rows. Any HELP

ThanksNo Pity!

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    51046 Posts
    Online
    Posted: October 3, 2009, 12:23 pm - IP Logged

    Cell H2: =SMALL(B2:F2,1)
    Cell I2: =SMALL(B2:F2,2)
    Cell J2: =SMALL(B2:F2,3)
    Cell K2: =SMALL(B2:F2,4)
    Cell L2: =SMALL(B2:F2,5)

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

      Avatar
      Iron Station, NC
      United States
      Member #74828
      May 21, 2009
      69 Posts
      Offline
      Posted: October 3, 2009, 2:58 pm - IP Logged

      That works great and save me lots of time, and was a fast reply.

      Thanks

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        51046 Posts
        Online
        Posted: October 3, 2009, 3:10 pm - IP Logged

        You're Welcome: Good Luck! Thumbs Up

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