dorothy831
New Member
- Joined
- Dec 1, 2004
- Messages
- 46
I have two files both may contain the same row of information, example my name is on both files. Is there a process to eliminate the duplicate rows of information?
Are we just looking for the same information in, say, column A of each file? Or are we looking at multiple columns that all have to be the same?I have two files both may contain the same row of information, example my name is on both files.
From one file (which one?) or from both?Is there a process to eliminate the duplicate rows of information?
Although not directly answered, I am guessing that the check needs to be on column C (name) only. Is that correct? In other words, if the same name appears in column C of each file then that is considered a duplicate and should be deleted?Are we just looking for the same information in, say, column A of each file? Or are we looking at multiple columns that all have to be the same?
When/if a duplicate is found is it to be deleted from both files or just one? If just one, which one?From one file (which one?) or from both?
What are the file names and the sheet names?Additional info that may help somebody assist you would be the file names, the sheet names