| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select/Sort Hierarichal Data in worksheet
Hi,
I need to Filter or Sort out the Hirearichal Employee and Manager information from below sample data structure. Empno Ename MGR Deptno 101 A 105 10 102 B 104 10 103 C 102 20 104 D 10 105 E 103 20 I want the Sorted/Filtered Data as per below. Empno Ename MGR Deptno 104 D 10 102 B 104 10 103 C 102 20 105 E 103 20 101 A 105 10 Kindly help me how to do the above in MS Excel 2003? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference another Worksheet and Conditionally Select Data | Excel Worksheet Functions | |||
| Select data onto new worksheet | Excel Discussion (Misc queries) | |||
| How do I use the data in a named field to select a worksheet tab . | Excel Discussion (Misc queries) | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Move select data to another worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
