Need Excel 07 Macro or formular to sort numbersPrev TopicNext Topic

• hotshot4

  

  Iron Station, NC
  United States
  Member #74,826
  May 21, 2009
  69 Posts
  Offline
  Oct 3, 2009, 12:11 pm

  ▲▼

  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

  Thanks
• Raven62

  

  25

  New Jersey
  United States
  Member #17,842
  June 28, 2005
  180,983 Posts
  Offline
  Oct 3, 2009, 12:23 pm

  ▲▼

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

  

  Iron Station, NC
  United States
  Member #74,826
  May 21, 2009
  69 Posts
  Offline
  Oct 3, 2009, 2:58 pm

  ▲▼

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

  Thanks
• Raven62

  

  25

  New Jersey
  United States
  Member #17,842
  June 28, 2005
  180,983 Posts
  Offline
  Oct 3, 2009, 3:10 pm

  ▲▼

  You're Welcome: Good Luck!

  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!