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 !

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 !

Excuse my ignorance by I have never created a pivot table. Is this something
I can read on or something you can elaborate on for me ?

Thank You For Any Help, and I love the name !

"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 !

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 !

Have you tried a VLookup? You can look in the one COl for "1" and bring back
the Data from the the Other Col.

"G Bonham" wrote:

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 !

Yes sir, I can easily accomplish a VLookup but the tricky part is to get
results from all columns, and display them on another sheet all in one
column. In other words all results from the first page with the number 1
next to them will display on the next sheet in one single column, without any
duplicates !


"Rich" wrote:

Have you tried a VLookup? You can look in the one COl for "1" and bring back
the Data from the the Other Col.

"G Bonham" wrote:

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 !