Deleting Duplicates from a File

[Connie]

I've not had success using the macros listed to delete
rows where the first cell is the same. For example,

* Sheet1 has name in column 1 (shorter file)
* Sheet2 has name in column 1 and address in column 2
(longer file)

I want Sheet1 to drive the selection of rows in Sheet2,
resulting in a name and address subset file of Sheet2.

Thank you,
Connie

 

[Andy B]

Connie

If I understand you correctly, you want to have the names and addresses from
Sheet2 that match the names from Sheet1.
If so, sort the info in Sheet2 by name and then try using VLOOKUP(). If your
name is in Sheet1 cell A2 (for example) try:

=VLOOKUP(A1,Sheet2!A:B,2,false) in B1 to bring the address from Sheet2

If this is right, you can then fill down for the rest of the cells in the
column.

Andy.

 

[Connie]

Thanks, I'll try it!

-----Original Message-----
Connie

If I understand you correctly, you want to have the names and addresses from
Sheet2 that match the names from Sheet1.
If so, sort the info in Sheet2 by name and then try using VLOOKUP(). If your
name is in Sheet1 cell A2 (for example) try:

=VLOOKUP(A1,Sheet2!A:B,2,false) in B1 to bring the address from Sheet2

If this is right, you can then fill down for the rest of the cells in the
column.

Andy.




.

 

[Guest]

I can't make this work....getting #N/A....my files

Sheet 1 - Column A
Carol
Connie
Mom
Sophie
Thom

Sheet 2
Carol Houston
Connie Wayzata
Jill SLP
Mom

 

[Andy B]

On sheet2, is each line of information all in one cell?

Andy.

 

[Connie]

In sheet 2 name is in column 1 and city is in column 2.

 

[Grateful Connie]

Thanks Andy B---I got it to work!