Hello
I have a table like:
I want to group ColA like that: <1, >1 and <2, >2 and <3, etc
I create a pivot but it says the selection cannot be grouped. I am not sure if because it's formatted as text or something? I changed formatting to Number but it does not seem to work.
Any solution?
Thanks!
I have a table like:
0.11981 | 1.00 |
0.13997 | 1.00 |
1.17338 | 1.00 |
1.21312 | 1.00 |
2.23328 | 1.00 |
2.27360 | 1.00 |
2.27994 | 1.00 |
3.36691 | 1.00 |
3.47347 | 1.00 |
3.95328 | 1.00 |
I want to group ColA like that: <1, >1 and <2, >2 and <3, etc
I create a pivot but it says the selection cannot be grouped. I am not sure if because it's formatted as text or something? I changed formatting to Number but it does not seem to work.
Any solution?
Thanks!
