Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

Advanced Sorting - urgent

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jesseboat - 14 Nov 2006 17:54 GMT
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
ChrisJ - 14 Nov 2006 19:17 GMT
This is what I would do: Assuming your data is in columns A thru E and that
there is one blank row between boxes, in column F create a formula for each
row in the box plus the blank row below it referring to the cell with the
salary difference (i.e. D4). Copy this box of four cells down through column
F. Copy and Edit, Paste Special, choose Value and click OK. In column G
create consecutive numbers from 1 thru whatever. Now sort the whole area with
a primary sort on column F and a secondary sort on column G.
Signature

ChrisJ
Omaha

> 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.
[quoted text clipped - 28 lines]
>
> Jesse
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.