I'm very inexperienced with excel formulas and using the wizard did not get me anywhere, so I need help.
I have 2 tables.
TABLE 1- 14981 rows
TABLE 2 - 50112 rows
Table 2 repeats some of the data that is already on table 1. The data in question in both tables is in column C.
I need to use table 2 but omit/delete the duplicate data from column C that it is already in Table 1.
How do I do that ?
Thanks a lot.
A quick cheap and nasty would be to copy table 1 to below table 2, then use excels built-in "remove duplicates" (Data tab/data tools) to remove the duplicates.
Another option would be to use the countif($C$1:C1,C1) function, copied down, then filter on all values >1, and then delete those rows >1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks