Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
top 10 subtotaling
Hello:
Recently, I just learned how to use the Subtotal feature in the Data menu in Excel. It's great! Now, is there a way to (after showing subtotals) have Excel show a "top 10" subtotals? I have a spreadsheet that shows subtotals of check amounts. I'd like to see the top 10 highest of those amounts. Is that possible in Excel and, if so, how? Thanks! childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
top 10 subtotaling
You are better off with a pivot table if that is what you are looking to do.
If you think subtotals are cool you ain't seen nothin yet. Remove the subtotals from your source data. Place you cursor anywhere inside fo the data and select Data - Pivot Tables and Charts When the wizard pops up you can just select finish (99.9% of the time XL will make all of the right assumptions). Drag your grouping criteria to the left column and put your check amounts in the data area. You should now get your subtotals. Right click on your grouping criteria and select Field Settings - Advanced - Show Top 10 -- HTH... Jim Thomlinson "childofthe1980s" wrote: Hello: Recently, I just learned how to use the Subtotal feature in the Data menu in Excel. It's great! Now, is there a way to (after showing subtotals) have Excel show a "top 10" subtotals? I have a spreadsheet that shows subtotals of check amounts. I'd like to see the top 10 highest of those amounts. Is that possible in Excel and, if so, how? Thanks! childofthe1980s |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
top 10 subtotaling
the top 10 stuff is not working. the data stays the same.
Thoughts? "Jim Thomlinson" wrote: You are better off with a pivot table if that is what you are looking to do. If you think subtotals are cool you ain't seen nothin yet. Remove the subtotals from your source data. Place you cursor anywhere inside fo the data and select Data - Pivot Tables and Charts When the wizard pops up you can just select finish (99.9% of the time XL will make all of the right assumptions). Drag your grouping criteria to the left column and put your check amounts in the data area. You should now get your subtotals. Right click on your grouping criteria and select Field Settings - Advanced - Show Top 10 -- HTH... Jim Thomlinson "childofthe1980s" wrote: Hello: Recently, I just learned how to use the Subtotal feature in the Data menu in Excel. It's great! Now, is there a way to (after showing subtotals) have Excel show a "top 10" subtotals? I have a spreadsheet that shows subtotals of check amounts. I'd like to see the top 10 highest of those amounts. Is that possible in Excel and, if so, how? Thanks! childofthe1980s |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
top 10 subtotaling
Hi,
With the subtotal, collapse the range and make a sorting. reagards Jean-Yves "childofthe1980s" wrote in message ... the top 10 stuff is not working. the data stays the same. Thoughts? "Jim Thomlinson" wrote: You are better off with a pivot table if that is what you are looking to do. If you think subtotals are cool you ain't seen nothin yet. Remove the subtotals from your source data. Place you cursor anywhere inside fo the data and select Data - Pivot Tables and Charts When the wizard pops up you can just select finish (99.9% of the time XL will make all of the right assumptions). Drag your grouping criteria to the left column and put your check amounts in the data area. You should now get your subtotals. Right click on your grouping criteria and select Field Settings - Advanced - Show Top 10 -- HTH... Jim Thomlinson "childofthe1980s" wrote: Hello: Recently, I just learned how to use the Subtotal feature in the Data menu in Excel. It's great! Now, is there a way to (after showing subtotals) have Excel show a "top 10" subtotals? I have a spreadsheet that shows subtotals of check amounts. I'd like to see the top 10 highest of those amounts. Is that possible in Excel and, if so, how? Thanks! childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotaling | Excel Worksheet Functions | |||
Subtotaling | Excel Worksheet Functions | |||
Subtotaling | Excel Worksheet Functions | |||
subtotaling | Excel Discussion (Misc queries) | |||
subtotaling every third row? | Excel Worksheet Functions |