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

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

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

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