Question Locked

Sorting data in one worksheet in another

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

This discussion is closed to new replies.