witchcraftz
New Member
- Joined
- Jan 17, 2008
- Messages
- 39
My pivot table data is a simple list of percentages, it is similar to the list below:
0%
10.01%
8%
100%
80%
20.2%
100%
90%
50%
6.6%
48%
I want to group the data this way:
<tbody>
</tbody>
I have read a some posts but I'm not sure how to do this.
The closest is this post but the grouping is wrong and my mind is having a hard time figuring out how to modify this for my purposes.
https://stackoverflow.com/questions/46912874/pivot-table-grouping-percentage-ranges-using-vba
0%
10.01%
8%
100%
80%
20.2%
100%
90%
50%
6.6%
48%
I want to group the data this way:
Percentage | Count |
100% | 2 |
75% to <100% | 2 |
50% to <75% | 1 |
25% to <50% | 1 |
0%> to <25% | 4 |
0% | 1 |
<tbody>
</tbody>
I have read a some posts but I'm not sure how to do this.
The closest is this post but the grouping is wrong and my mind is having a hard time figuring out how to modify this for my purposes.
https://stackoverflow.com/questions/46912874/pivot-table-grouping-percentage-ranges-using-vba