simple formula needed for groupings

D

Debbie60

Hi, I'm using excel 2007 for a customer address database and need a formula
to compile listings grouped by same suburb and then same areas eg: south
west, west etc. Also, how do have the grouped information print on another
worksheet whilst retaining the orginial info on the orginial worksheet.
EG: cell a b c d
1 Brown apple st sydney west
2 Jones pear rd penrith north west
many thanks
 

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


Top