I quickly played with a pivot table ... however I just want to export one
single list with only the animals that have a 1 next to them, without listing
any duplicates.

Any ideas ?

"Teethless mama" wrote:

Create a Pivot table
http://www.contextures.com/tiptech.html



"G Bonham" wrote:

A B C D
1 DOG 1 CAT 1
2 CAT 0 PIG 1
3 PIG 0 DOG 0
4 COW 1 COW 0
5 DOG 0 MOOSE 1
6 PIG 0 DEER 0
7 CAT 0 COW 0
8 DOG 0 DOG 0
9 PIG 1 CAT 0


Using the simple layout above I would like to use another sheet to find all
the animals with a 1 next to them, then display them, in seperate cells, in
the same column in another sheet within the same workbook. Is this possible
and what is the easiest route to accomplish this task ? Also if they ever
repeated, duplicates, ensure the list only had one entry for each animals.
In other words if Dog had a 1 next to it in both columns, it would only list
Dog once on the next sheet.

This will be done across many columns, approx 20, and approx 120 rows.

Any Help is greatly greatly appreciated !