top 10 subtotaling

[childofthe1980s]

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

 

[Jim Thomlinson]

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

 

[childofthe1980s]

the top 10 stuff is not working. the data stays the same.

Thoughts?

 

[Jean-Yves TFELT]

Hi,

With the subtotal, collapse the range and make a sorting.
reagards
Jean-Yves