Grouping

G

Guest

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.
 
D

Debra Dalgleish

What do you want to do with the spreadsheet when it's grouped? If you
want totals for each value, you could use the Data>Subtotals feature, or
Data>PivotTable and PivotChart Report, to group and summarize the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving row data to a colunm in sorted order 9
Average Value 34
Formula (or code) return the largest number of duplicates in a list. 16
Finding values in different rows/columns 1
Remove/Nullify Sort 2
linking rows 1
Figuring out a lengthy formula. Probably quite simple... 3
Keeping Rows Together 1

Top