Hi ! i am new to excel and i want to know how to sort word by its value ?
This is right order of rank
1) Recruit
2) Private
3) Gefreiter
4) Corporal
5) Master Corporal
6) Sergent
7) Staff Sergeant
8) Master Sergeant
9) First Sergeant
10) Sergeant-Major
so i want to sort them by there value not by A to Z or length etc. please help
Bookmarks