Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Sorting - urgent
I would like to sort a box of data by one cell in each box, rearranging the
boxes while keeping the data in each individual cell intact. In the example below, I would like to sort the boxes (imagine lines around each company) by the difference in the salaries betweern President and VP- lowest to highest. So the companys should be organized Company 2 (with all its info intact), then company 3, then company 1. Example: Companies with names of CEOs and salaries Company Name Title Salary Bonus Company1 AJ Feele President 999999 400000 Tom Cruise VP 777777 200000 222222 200000 Company2 MLK Jr. Pres 300000 15000 Howard Stern VP - Sales 200000 13000 100000 2000 Company3 Heinz Ward Pres 500000 150000 Ghandi VP 100000 50000 400000 100000 I do not care if the cells are combined somehow, I just need to make sure I can sort by the difference in salary or the diffrence in bonus. The regular sort funcion cannot do this and I would not like to move them manually because I have hundreds to sort this way. If you have any insights, PLEASE let me know. I greatly appreciate your time and help. Jesse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blanks and Advanced Filters | Excel Discussion (Misc queries) | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Advanced Sorting #'s?? | Excel Discussion (Misc queries) | |||
Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) |