Hey guys,
I have a full sheet of data that i've macro'd in to a pivot table. However, i cant work out how to then tell the macro to group Rows by a cell value that is below or equal to a few set values.
Here's a screenshot of what i'm trying to group:
The values 0.01, 0.09, 0.11 continue infinitely but rarely pass 161.99.
Here is what i'm trying to achieve:
The groups i'd like to put the values in are:
0.00 - 2.49 (Group 1 in diagram)
2.50 - 4.99 (group 2)
5.00 - 9.99 (group 3)
10.00 - 14.99 (group 4)
15.00 - 24.99 (group 5)
25.00 - 49.99 (Group 6)
50.00 + (not in above pic as no values above 49.99, but would presumably be group 7)
The groups dont need to be renamed, i'm just going to copy and past the data out of the pivot table into a final spreadsheet anyways.
Any idea's guys? i'm truly at a loss for this one.
any help appreciated.
I have a full sheet of data that i've macro'd in to a pivot table. However, i cant work out how to then tell the macro to group Rows by a cell value that is below or equal to a few set values.
Here's a screenshot of what i'm trying to group:
![excel.jpg](/board/proxy.php?image=http%3A%2F%2Fi11.photobucket.com%2Falbums%2Fa180%2FKrhl%2Fexcel.jpg&hash=bf6bad62bda05b0a8e7bad3bbcd2f6a2)
The values 0.01, 0.09, 0.11 continue infinitely but rarely pass 161.99.
Here is what i'm trying to achieve:
![excelgrouped.jpg](/board/proxy.php?image=http%3A%2F%2Fi11.photobucket.com%2Falbums%2Fa180%2FKrhl%2Fexcelgrouped.jpg&hash=d0cc6be63e77e8d4bd532bdc214cd62f)
The groups i'd like to put the values in are:
0.00 - 2.49 (Group 1 in diagram)
2.50 - 4.99 (group 2)
5.00 - 9.99 (group 3)
10.00 - 14.99 (group 4)
15.00 - 24.99 (group 5)
25.00 - 49.99 (Group 6)
50.00 + (not in above pic as no values above 49.99, but would presumably be group 7)
The groups dont need to be renamed, i'm just going to copy and past the data out of the pivot table into a final spreadsheet anyways.
Any idea's guys? i'm truly at a loss for this one.
any help appreciated.