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. ...
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.