I want to sort well over a 1000 rows to find the same group of 4 digits. How can I do this? For example I want to sort these below and I want to be able to have say the 1245's together. I will upload an example spreadsheet
1223
1245
1857
4854
1548
4524
1234
1245
1542
7845
Use the sort option... (first sorting level on column B, second on C, third on D, fourth on E)
When I say semicolon, u say comma!
Go to Data, Sort, Click on Options and make sure it is set for Top to Bottom, then set up your sort ascending for column B, C, D, and E.
Thanks, that got it
Originally Posted by 6StringJazzer
If your question has been answered please mark your thread as "Solved" so that members will know that your problem is solved.
Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you! I was uncertain how to do that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks