Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double Sorting of Data
I have a worksheet of raw data that needs to be sorted and summarized. Column A contains the department code: A, B, C, or D Column B contains the account code: 100, 200, 300, 400, or 500 Column C contains the dollar amount for each I need to sort the data twice: Once to group all dept. codes, and then further to group all the account codes within that department. For example, for department A -- I need to summarize the total dollar amount for account code 100, then for account code 200, and so on. I need to do the same for each of the departments A through D. The SUMIF formula is what I think I need, but how do you sort twice? I can sort the data to total the dollar amounts by Department or by account Code, but I need to sort by both simultaneously. Thanks -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=503188 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double Sorting of Data
Use Data, Sort instead of the button
for more information on sorting see http://www.mvps.org/dmcritchie/excel/sorting.htm for information on searching Excel newsgroups see http://www.mvps.org/dmcritchie/excel/xlnews.htm -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "LACA" wrote in message ... I have a worksheet of raw data that needs to be sorted and summarized. Column A contains the department code: A, B, C, or D Column B contains the account code: 100, 200, 300, 400, or 500 Column C contains the dollar amount for each I need to sort the data twice: Once to group all dept. codes, and then further to group all the account codes within that department. For example, for department A -- I need to summarize the total dollar amount for account code 100, then for account code 200, and so on. I need to do the same for each of the departments A through D. The SUMIF formula is what I think I need, but how do you sort twice? I can sort the data to total the dollar amounts by Department or by account Code, but I need to sort by both simultaneously. Thanks -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=503188 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Sorting data rows independently | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |