Wednesday, 24 February 2016

Trick : Sort the IDs List

Trick : Sort the IDs List.


If you have the IDs column list as in our example A1, A2 … A100..A200 (Column C ) and you need to sort the list accordingly. Then, simple sorting wouldn’t helpful you anyways.


For that, you need to convert the list as A001, A002, A003…A100..A200 (Column D).
Create the list with this formula in Column D =LEFT(C3,1)&RIGHT("000"&RIGHT(C3,LEN(C3)-1),3)





 And then , Sort it with help of new list .


And Here you get the desired result.

Thank You !! :)

No comments:

Post a Comment