Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grouping
I have several columns in a spreadsheet and the spreadsheet ahs to be Group
by One column and Sort by Another one. I can use Data Sort option and sort the whole spread sheet with respect to particular column but I cannot group it. Grouping means all the data with similar values should be together. If there are 5 rows with values like 33, 44, 33, 44, 22 then the both the rows of 33 should be together and 44 should be together too. |
#2
|
|||
|
|||
What do you want to do with the spreadsheet when it's grouped? If you
want totals for each value, you could use the DataSubtotals feature, or DataPivotTable and PivotChart Report, to group and summarize the data. Rachana wrote: I have several columns in a spreadsheet and the spreadsheet ahs to be Group by One column and Sort by Another one. I can use Data Sort option and sort the whole spread sheet with respect to particular column but I cannot group it. Grouping means all the data with similar values should be together. If there are 5 rows with values like 33, 44, 33, 44, 22 then the both the rows of 33 should be together and 44 should be together too. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping | Excel Discussion (Misc queries) | |||
How to unprotect Grouping controls | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) | |||
Pivot date grouping | Excel Discussion (Misc queries) |