• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtotal only for two or more items

A

abhayxl

New Member
Hi,

I want to use subtotal and group only for names which have more than 2 values.
And not for the one with only 1 value.Is there any shortcut to do it.

Enclosing the sample file.

Thanks,
Abhay
 

Attachments

  • Subtotal.xlsx
    9.7 KB · Views: 6
Just curious, why not go ahead and create the subtotal for the one item? With the condensed outline, it would look the same.
 
Hi Luke,

The problem arises when you have many single names.Creating an extra line(Subtotal) in the schedule doesnot look pretty.
 
Can you use a helper column? It would contain a formula to identify which names were listed more than once, and they might be grouped as shown, and for all names where it was listed only once, they are grouped in a single "All Others" group.

It generally isn't good practice to show a sub-grouping that doesn't equal the original total. Often that is a sign of some sort of manipulation of data.
 
Could also just use a PivotTable. I prefer those over subtotals, as it doesn't mess up the alignment of my raw data, and I can easily sum/count/average any of the settings.

upload_2016-5-4_12-36-47.png
 
I personally like Pivot Tables, as suggested by Luke M. Maybe you could add a COUNT and only show the ones with a count >1
 
You must log in or register to reply here.
Back
Top