ExcelBanter - View Single Post - Search cells based on criteria and display results in a single col

Teethless mama

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 !