Question
May 15, 2007 at 05:27 AM
rians

Sorting data in one worksheet in another

by rians . Updated 19 years, 5 months ago

I have a worksheet with a drop down list containing about 10 items. Obviously as the list is used these items are selected and the list could typically look like this:
dogs
cats
pigs
cats
cats
dogs
elephants.

For each of these animals there is also a name, which could be different.

On a separate worksheet I want the data to be automatically group according to type, in other words, I want all the dogs’ names to be grouped together and then all the pigs names etc.

Is there anyway to do this except for doing it manually?

This discussion is locked

All Comments