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
--
debbie