LinkBack URL
About LinkBacks
Hi friends,
I want to sort the range C5:C1000 in ascending order. I’m not getting it in ascending order after sorting.
Any help will be highly appreciated.
Thanking you,
Hi friends,
I want to sort the range C5:C1000 in ascending order. I’m not getting it in ascending order after sorting.
Any help will be highly appreciated.
Thanking you,
Sincerely,
mso3
Because they are not numbers - they are text.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If your data were in the same format E01, E02, etc, then it would sort perfectly.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Item Sort As E1 E01 D5: =PadNum(C5, 2) E10 E10 E11 E11 E12 E12 E12 E12 E13 E13 E2 E02 E3 E03 E4 E04 E5 E05 E6 E06 E7 E07 E8 E08 E9 E09 H1 H01 H10 H10 H11 H11 H13 H13 H13 H13 H14 H14 H2 H02 H3 H03 H4 H04 H5 H05 H6 H06 H7 H07 H8 H08 H9 H09 M1 M01 M10 M10 M11 M11 M12 M12 M13 M13 M14 M14 M15 M15 M16 M16 M17 M17 M18 M18 M2 M02 M3 M03 M4 M04 M5 M05 M6 M06 M7 M07 M8 M08 M9 M09
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
I'd forgotten about PADNUM...
@shg,
Thank you. It's fine but now it's not possible for me to change the data structure, insert 1 helping column in the database. So is there any solution to achieve the target in single column 'C' only.
To make the number format same I would like to have 5 digits as E00001, H00001, M00001 and so on.
A macro solution will be accepted.
Thank you to Ali and Glen.
Last edited by mso3; 04-03-2017 at 08:44 PM.
Hi Glenn,
How to set the custom number format to achieve it. To make the number in same size I have decided to make it 5 digits number. So the number E1 will be E00001, E2 will be E000002 and so on ...
Thanking you.
Please Login or Register to view this content.
Hi shg,
Excellent! Perfect as per the requirement.
Thank you and have a nice time.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks