Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Sorting groups in groups due to subtotaling
I need to know how to sort numbers in groups when they are within
groups due to subtotaling. I want to be able to sort each company by descending order by Sales number. Here is an example: Customer Name Product Name Sales ABC Company Product 1 880 Product 2 220 Product 3 400 Subtotal 1,420 DEF Company Product 1 700 Product 2 1,250 Product 3 100 Subtotal 2,050 I need to know (as they say) yesterday, if anyone can help!!!!! Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Sorting groups in groups due to subtotaling
Try using a pivot table, and do grouping within the pivot table.
Thanks. -- when u change the way u look @ things, the things u look at change. " wrote: I need to know how to sort numbers in groups when they are within groups due to subtotaling. I want to be able to sort each company by descending order by Sales number. Here is an example: Customer Name Product Name Sales ABC Company Product 1 880 Product 2 220 Product 3 400 Subtotal 1,420 DEF Company Product 1 700 Product 2 1,250 Product 3 100 Subtotal 2,050 I need to know (as they say) yesterday, if anyone can help!!!!! Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Sorting groups in groups due to subtotaling
I have not worked with pivot tables much, could you guide me?
Thanks again!!! On Apr 2, 2:53*pm, wrote: I need to know how tosortnumbers ingroupswhen they arewithingroupsdue to subtotaling. I want to be able tosorteach company by descending order by Sales number. Here is an example: Customer Name * Product Name * *Sales ABC Company * * Product 1 * * * * * * * * * * * * 880 * * * * * * * * * * * * Product 2 * * * * * * * * * * * * 220 * * * * * * * * * * * * * * * * Product 3 * * * * * * * * * *400 Subtotal * * * * * * * * * * * * * * * * * * * * * * * *1,420 DEF Company * * Product 1 * * * * * * * * * * * *700 * * * * * * * * * * * * Product 2 * * * * * * * * * * * 1,250 * * * * * * * * * * * * * * * * Product 3 * * * * * * * * * *100 Subtotal * * * * * * * * * * * * * * * * * * * * * * * *2,050 I need to know (as they say) yesterday, if anyone can help!!!!! Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Sorting groups in groups due to subtotaling
Arrange your data in list format: Say you have Year in A1, CompanyName in B1,
ProductName in C1, and Sales in D1. Your data will go from A2:D100 (or any range). Click on Data Pivot table and pivot chart select Excel list then click next click on the A:D headers so the entire columns selected this way your report will expand automatically each time you add more data to the list Click next drag the 'Year' field into the 'Page section', and the CompanyName and ProductName fields on the 'Row' section, and finally add the 'Sales' field to the 'Data section' double click on the new sales button and select SUM instead of count Next Finish. Your pivot table report is ready. You can group, ungroup, format, etc the report the way you like. Now your Products are grouped within each company/customer. If you would like to sort the sales in Ascending/Descending order, double click the sales button click on Advance and sort your products based on sales. Look in the help section for more details about the pivot tables. H.T.H. -- when u change the way u look @ things, the things u look at change. " wrote: I have not worked with pivot tables much, could you guide me? Thanks again!!! On Apr 2, 2:53 pm, wrote: I need to know how tosortnumbers ingroupswhen they arewithingroupsdue to subtotaling. I want to be able tosorteach company by descending order by Sales number. Here is an example: Customer Name Product Name Sales ABC Company Product 1 880 Product 2 220 Product 3 400 Subtotal 1,420 DEF Company Product 1 700 Product 2 1,250 Product 3 100 Subtotal 2,050 I need to know (as they say) yesterday, if anyone can help!!!!! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Groups of Rows | Excel Discussion (Misc queries) | |||
Sorting into Groups equal size | Excel Worksheet Functions | |||
Sorting with groups | Excel Discussion (Misc queries) | |||
Sorting by Groups | Excel Discussion (Misc queries) | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |