How to group employee experience numbers 11.03, 0.11, 10.00 in pivot table and then it should get the count

vijavad

New Member
Joined
May 27, 2017
Messages
17
Platform
  1. Windows
Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how many members and finally how many members with 10+ years of experience. So i tried grouping these experience numbers but it says' Cannot group that selection".
So please help me how to get rid out of this situation.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
11
424#####
1359@@@@@
1182
15105
35020
13
14
4
14
10####=SUMPRODUCT(($A$1:$A$40<=G2)*1)
14@@@@@=SUMPRODUCT(($A$1:$A$40<=G3)*1)-SUM($H$2:H2)
15
4
11
1
9
11
10
9
15
4
13
14
12
15
13
14
5
7
10
2
8
3
13
13
1
5
2
5

<colgroup><col span="6"><col><col span="8"></colgroup><tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top