Group identical cells

  • Thread starter Thread starter Daniel Louwrens
  • Start date Start date
D

Daniel Louwrens

I have Excel 2000 SP3

I have a worksheet about 600 rows long and have
several repeats of data in column (a).
I need to group these and then seperate them, so I can work on them as
separate groups.
Is there some way of doing that automatically.

thanks

Daniel
 
Daniel,

Have you tried to filter the list using autofilter?
you will find the tool under tools>filter>autofilter.

It will allow you to operate on subsets fo the dat
 
Thanks

that has sorted them for me but I can only access them one at a time, is it
possible to have the groups all vivible at the same time?

Daniel
 
Back
Top