Comparing data across two tables (worksheets)

Works when two Excel files are selected. Function extracts unique values for one of the files. The search is carried out by specified column. If you choose option Both Files then processing results will include unique values found in the first and the second file.

How to find unique values in one column you can learn here

Example:

Find unique values for column Name in File 1:

File 1:

	Name	Office	Telephone	Department	Position	Hobby
1	Michael	304	1304	Financial	Analyst	Football
2	Helen	318	1318	Personnel	Manager	Music
3	Mr. Gauge	301	1301	Administration	Manager	Travel
4	Bob	315	1315	Design	Designer	Lacrosse
5	Erik	302	1302	Car Pool	Driver	Racing

File 2:

	Name	Office	Telephone	Department	Position	Hobby
1	Michael	304	1304	Financial	Analyst	Football
2	Erik	302	1302	Car Pool	Driver	Racing
3	Helen	318	1318	Personnel	Manager	Music
4	Mr. Gauge	301	1301	Administration	Manager	Travel

Output table:

	Name	Office	Telephone	Department	Position	Hobby
1	Bob	315	1315	Design	Designer	Lacrosse

learn more

We want you to find this page by the following keywords:

^{unique values between two files, across two worksheets, retrieving unique records from a list, distinct records in a column, how to find distinct entries between 2 columns, comparing across two columns}

functions:

how it works:

load two files
open Function Wizard
choose Unique Values function
select the column to search for unique values
specify file number
press Run button to get the results

download filord

buy now