Need Excel 07 Macro or formular to sort numbers https://www.lotterypost.com/thread/201581 Lottery Post Forum Topic: Need Excel 07 Macro or formular to sort numbers en-us Lottery Post RSS Generator Reply #3 https://www.lotterypost.com/thread/201581/1421043 https://www.lotterypost.com/thread/201581/1421043 Sat, 03 Oct 2009 19:10:32 GMT Raven62 You're Welcome: Good Luck

]]> Raven62 Reply #2 https://www.lotterypost.com/thread/201581/1421024 https://www.lotterypost.com/thread/201581/1421024 Sat, 03 Oct 2009 18:58:45 GMT hotshot4 That works great and save me lots of time, and was a fast reply.

Thanks

]]> hotshot4 Reply #1 https://www.lotterypost.com/thread/201581/1420881 https://www.lotterypost.com/thread/201581/1420881 Sat, 03 Oct 2009 16:23:51 GMT Raven62 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

]]> Raven62 Need Excel 07 Macro or formular to sort numbers https://www.lotterypost.com/thread/201581 https://www.lotterypost.com/thread/201581 Sat, 03 Oct 2009 16:11:29 GMT hotshot4 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

]]> hotshot4