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 Here you get the desired result.
Thank You !! :)
No comments:
Post a Comment