For a more manual approach, try this:

Insert a blank sheet
A1: Name
B1: Unique?
Copy your Col_A list into the new sheet, beginning on cell A2.
Copy your Col_G list into the new sheet, immediately under the first list.

B2: =COUNTIF($A$1:$A$2834,A1)=1
Copy that formula down thru B2834

Then select A1:B2834
DataFilterAutoFilter
Click on the Unique? dropdown and select TRUE

There's your list of unique names.
(adjust range references if necessary)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jill" wrote:

Thanks Ron - I learned something new, however, when I did the filter, it gave
me the names of the persons who are in both columns. I want the names
filtered out that only appear once. In other words, I have two sets of
names. Most of the names are in both columns. I am trying to locate those
that appear in one or the other column. Thanks

"Ron Coderre" wrote:

Try this:

Using a list of 1,377 names in Col_A with a column heading in A1 and another
list of names in cells G2:G100.

A1: Name
C1: Name

H1: Test
H2: =ISNUMBER(MATCH(A2,$G$2:$G$100,0))

Select cells A1:A1377
DataFilterAdvanced Filter
Check: Copy to another location
List Range: (already selected a1:a1377)
Criteria: (Select $H$1:$H$2)
Copy to: (Select $C$1)
Click the [OK] button

The list of matching names will be copied below Cell C1.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jill" wrote:

Hi I have two columns of names - Column A 1,377 names, Column G 1,456 names.
Most are duplicates. I want to see the names in another column that are not
duplicates. How do I use VLOOKUP to do this? Or do you have any other
suggestions?