Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Sort Question
I have a worksheet that has 10 salesmen listed. For each person there
are 3 rows of information. The 1st row is total overall sales. The 2nd row is sales for one company and the 3rd row is for another company. Each row contains a breakdown of various information that is being looked up on other sheets. What I would like to do is sort 1st by total sales putting that salesman at the top of the list but leave the other 2 rows with the first. Here is an example: (using 8 columns of lookup data. Last one is total sales and using it to sort) Row 1 - person A total sales Row 2 - person A sales for company A Row 3 - person A sales for company B Row 4 - person B total sales Row 5 - person B sales for company A Row 6 - person B sales for company B Row 7 - person C total sales Row 8 - person C sales for company A Row 9 - person C sales for company B Repeats for all 10 people. Is it possible to link or lock some how all three of them together? If so my next question is going to be if it is possible to automatically sort the other 2 rows to always put the highest company first. I have not had a need to use macros but I would be willing to try anything at this point. Thanks in advance, Chas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Sort Question
Not sure how you want to use this data, but if they are already in a block, add a column to distinguish each row (eg T for total, A and B for each company), then filter the data on T to see only the total rows. To turn on the filter - Data, Filter, Filter Then a dropdown appears on all the column headings - click on the new column and select T. Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=522907 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Sort Question
Mike, that was a good suggestion, but the sheet this information will
be on is going to be used as a lookup table for a report page. Each week I want to be able to sort the salesman on the page I mentioned so I can call the information from a set cell for the report sheet. If the auto sort option can be used for the other 2 rows, I can add additional information to the report. I would like to keep the information grouped together for my own use, too see where the sales for each are coming from. I may need to do this in 2 sheets. Chas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort & Page Setup Question | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Keeping Row 1 at the top during a Data Sort... | Excel Worksheet Functions | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |