I need a formula for grouping data

  • Thread starter Thread starter Debbie60
  • Start date Start date
D

Debbie60

hi, I'm using excel 2007 as a database for customer addresses and I need a
formula to group the data by suburb and then also by regions. I also need to
know how to print this data by suburbs & region on a seperate worksheet and
retain the info on the orginial worksheet.
eg cell a b c d
1 Brown apple st tempe south west
2 Jones pear rd penrith metro west
many thanks debbie
 
You sound like you need a Pivot Table - Data - Pivot Table and Pivot Charts.

Make sure you've got your desired table highlighted when using.

Drop your desired groups into the Row Fields.

You can also drop somethign into the data fields to get, say, the number of
times each of these groups appears on the spreadsheet.
 
thanks will give it a try
--
debbie


Sean Timmons said:
You sound like you need a Pivot Table - Data - Pivot Table and Pivot Charts.

Make sure you've got your desired table highlighted when using.

Drop your desired groups into the Row Fields.

You can also drop somethign into the data fields to get, say, the number of
times each of these groups appears on the spreadsheet.
Click to expand...
 
Back
Top