K
klafert
I need help with comparing two columns. I have two spreadsheets and I think
I have some duplicate entries in each of the two spreadsheets. Some however
aren’t. I need to figure out which are duplicates and which aren’t? I am
importing data, but I want it to go in only once.
In each spreadsheet I have a column named “Account ID†(Column B) and a
Column named “Amount†(Column E).
I need to import only the non-duplicates from both spreadsheets. Just to
clear up when I say duplicates, I mean that the entry is in both spreadsheets
not duplicated in one spreadsheet.
Example:
Spreadsheet 1
Account ID (Column B) Amount (Colum E)
412-23 200.00
512-34 400.00
613-789 500.00
Spreadsheet 2
Account ID (Column B) Amount (Colum E)
412-23 200.00
512-34 400.00
789-10 600.00
Then I would compare and only import 789-10 for 600.00, because the other
entries are duplicated in each spreadsheet.
I have some duplicate entries in each of the two spreadsheets. Some however
aren’t. I need to figure out which are duplicates and which aren’t? I am
importing data, but I want it to go in only once.
In each spreadsheet I have a column named “Account ID†(Column B) and a
Column named “Amount†(Column E).
I need to import only the non-duplicates from both spreadsheets. Just to
clear up when I say duplicates, I mean that the entry is in both spreadsheets
not duplicated in one spreadsheet.
Example:
Spreadsheet 1
Account ID (Column B) Amount (Colum E)
412-23 200.00
512-34 400.00
613-789 500.00
Spreadsheet 2
Account ID (Column B) Amount (Colum E)
412-23 200.00
512-34 400.00
789-10 600.00
Then I would compare and only import 789-10 for 600.00, because the other
entries are duplicated in each spreadsheet.