Forum Discussion
Grouping in Excel - Number being Counted repeatedly
Hello Experts, I have a data set, in which unique items have been sold at different discount percentages. I want to know in which bracket of discount how many items are there for offering. ...
I guess we speak about grouping in PivotTable. Such grouping is by design and it's not overlapping of ranges. Just
0 - 10% means ( >= 0 and <= 10% )
10% - 20% means ( > 10% and <= 20% )
20% - 30% means ( > 20% and <= 30% )
etc
First bin includes first number of the range, next bins take all what is greater of first number (and not more than the second one)
Thank you for the revert.
@Sergei, but this kind of pattern is not getting reflected in other worksheets. Only in a particular sheets with some data points grouping in being overlapped. So curious to know why and how this can be fixed, but I get your point. Thank you again.
@Sergei, but this kind of pattern is not getting reflected in other worksheets. Only in a particular sheets with some data points grouping in being overlapped. So curious to know why and how this can be fixed, but I get your point. Thank you again.
As SergeiBaklan remarked, there is no overlap in the counts: the total 9297 is correct.
Excel has to write 0.1-0.2 and 0.2-0.3 because these are numbers with decimals, not whole numbers.
I don't think it is possible to make Excel display the groups as percentages 10%-20% etc.
You'd have to create your own list with COUNTIFS formulas for that.
