Comparing columns on two different spreadsheets

Closed
willerdt
Posts
1
Registration date
Monday August 1, 2016
Status
Member
Last seen
August 1, 2016
- Aug 1, 2016 at 01:24 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Aug 1, 2016 at 01:50 PM
I have two lengthy spreadsheets and want to compare columns labeled "NAME" on each to determine which names are on either that are not on the other.

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 1, 2016 at 01:50 PM
willerdt, Good afternoon.

You can use a VLOOKUP Function or a combination of INDEX + MATCH Functions.

It depends on the layout of your files.
As you did not mentioned how is your layout, we can not helps you conclusively at this moment.

If you want, save your file at a free site, www.speedyshare.com, and put a link to download here.
It's easier for us to help you.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0