sorting
can anyone please help me out sorting the following like i have the data as
below S.No Name Designation Grade 1 x AM E1 2 y AM E1 3 z Asst. E10 4 a Asst. E10 5 b Asst. E10 6 c Mgr E2 7 d Mgr E2 8 e Mgr E2 9 f Sr. Mgr E3 10 i Sr. Mgr E3 my problem here is when im trying to sort it on Grade it is giving as E1 then E10 then E2 then E3 but i should get it as E1 then E2 then E3 and then E10 please help me out in resoving ths immediately |
sorting
Try the below custom sort
--Create a list of grades in the order you prefer E1 E2 E3 E10 --Then select the above range of cells. From ToolsOptionsCustom Lists tabImport button.. to import this as a new custom list.. --From menu DataSort Select 'Sort by' and then click 'Options' select the custom list and select the orientation... -- Hit OkOK... If this post helps click Yes --------------- Jacob Skaria "User" wrote: can anyone please help me out sorting the following like i have the data as below S.No Name Designation Grade 1 x AM E1 2 y AM E1 3 z Asst. E10 4 a Asst. E10 5 b Asst. E10 6 c Mgr E2 7 d Mgr E2 8 e Mgr E2 9 f Sr. Mgr E3 10 i Sr. Mgr E3 my problem here is when im trying to sort it on Grade it is giving as E1 then E10 then E2 then E3 but i should get it as E1 then E2 then E3 and then E10 please help me out in resoving ths immediately |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com