ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Advanced Sorting - urgent (https://www.excelbanter.com/excel-worksheet-functions/118788-advanced-sorting-urgent.html)

Jesseboat

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


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com