RSS 2.0 Feeds
Latest Forum Topics
Web Site Change Log
RSS info, more feeds
Topic closed. 3 replies. Last post 7 years ago by Raven62.
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
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!
That works great and save me lots of time, and was a fast reply.
You're Welcome: Good Luck!
If you haven't already, check out the About Us page that explains the main features of our site.
Also, please take a few moments and review the rules for posting at Lottery Post.
Any time you see a gray-underlined link, you can click the link to see a popup menu of options.
We try to include instructions on each page. Check for help content on the page that's giving you trouble.
The next place to seek help is our dedicated Help forum that contains detailed assistance for frequently requested topics.
If something isn't working properly, our automated Browser Test page can quickly identify common problems.
Finally, the Contact Us page has an incredible wealth of self-help material that answers 95% of the questions we are asked.
We always welcome feedback and suggestions.
About Us • Site Map • Membership Features • Advertising Opportunities • Change Log • Rules • Linking to Lottery Post
Index of Feeds • Lottery News • Event Calendar • Latest Forum Posts • Web Site Change Log
Search the news, forums, blogs, and even your private messages at our Search page.
This page was generated in 0.0421 seconds.Copyright © 1999-2017 Speednet Group. All rights reserved.