lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this
18-30
31-50
51-65
So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done here with a regular table not pivot? Thank you very much
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this
18-30
31-50
51-65
So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done here with a regular table not pivot? Thank you very much
name | sex | age | dept |
mary1 | f | 39 | hr |
linda1 | f | 26 | it |
kim1 | f | 19 | sales |
allen1 | m | 38 | it |
adam1 | m | 49 | marketing |
mary2 | f | 50 | sales |
linda2 | f | 61 | marketing |
kim2 | f | 26 | hr |
allen2 | m | 26 | it |
adam2 | m | 27 | sales |
mary3 | f | 59 | it |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>