I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.

You could copy the contents of the two source columns into a single column,
then use either the AutoFilter or Advanced Filter method to remove the
duplicates.

These are found under Data / Filter on the worksheet menu bar, and you
should note that the range to be filtered needs to have a header row at the
top.

Hope that helps,

TK

" wrote:

I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.

Oops, after re-reading your post I don't think the AutoFilter will do what
you want; you need to use the Advanced Filter and check the 'Unique records
only' to eliminate the duplicate values.

"T Kirtley" wrote:

You could copy the contents of the two source columns into a single column,
then use either the AutoFilter or Advanced Filter method to remove the
duplicates.

These are found under Data / Filter on the worksheet menu bar, and you
should note that the range to be filtered needs to have a header row at the
top.

Hope that helps,

TK

" wrote:

I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.

I was hoping not to have to copy in case worksheet 1 or 2 gets
information added to it, I would want that new information in the
consildated spreadsheet.

Thanks,
Brian


T Kirtley wrote:
Oops, after re-reading your post I don't think the AutoFilter will do what
you want; you need to use the Advanced Filter and check the 'Unique records
only' to eliminate the duplicate values.

"T Kirtley" wrote:

You could copy the contents of the two source columns into a single column,
then use either the AutoFilter or Advanced Filter method to remove the
duplicates.

These are found under Data / Filter on the worksheet menu bar, and you
should note that the range to be filtered needs to have a header row at the
top.

Hope that helps,

TK

" wrote:

I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.