How To Group Percentages in Excel Pivot Table

Objective:

1. You have a column that contains percentage
2. Then you want to group the percentage by certain range. For example:
• By 10%: 1-10%, 11-20%, 21-30% and so on
• By 20%: 1-20%, 21-40%, 41-60% and so on
3. Insert 1 column and apply below formula linked to the percentage

Range of 10%:

TEXT(IF(A1<=0.1,0,CEILING(A1,0.1)*100-9),"0-")&TEXT(CEILING(A1,0.1),"0%")

Range of 20%:

TEXT(IF(A1<=0.2,0,CEILING(A1,0.2)*100-19),"0-")&TEXT(CEILING(A1,0.2),"0%")

The group is useful for you to summarize your data by using pivot table.