Greetings,
I've been working on this for a while (the attached is a current sample that is not part of the original Workbook).
I am needing to sort a column with some of the cell values containing an "-" (Ex: 103-A and 10-C). The sort does not include those cell values.
Any help would be greatly appreciated.
One way, assuming we can use column B:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
THats because if you have anything other than a number in a cell, excel sees that as text - and all text sort together, all values sort together
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
TMS,
Works great!!!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks