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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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