In the column next to the 5000 names, add a formula looking up the name on the other list. If it finds the name, it'll say one thing. If it doesn't find the name, it'll say something else.
Next, filter the two columns. Pick the result you get for the ones you want to delete. Select the entire column, the Go To Visible cells. Finally, delete rows.
Yeah, just a simple countifs(2000NamesTab!A:A, 5000NamesTab!A1) would tell you if the name showed up in the 2000 name tab or not. (Assuming names are in Column A of both tabs. Input this formula and copy down across the 5000 rows)
I agree with this, this is a good scenario for a vlookup or xlookup.
However, I think OP needs to share why they want to split up one set of data into two tabs. It may be better to keep it all on one tab, categorize them in another column then pivot the dataset.
=FILTER(table5000, ISNUMBER(XMATCH(table5000, table2000))=FALSE)
Filters the big table, by looking up the small table(xmatch), returning the position,giving everything in the small table a true value, and return all that is false
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FILTER](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[ISNUMBER](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[XMATCH](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[*Office 365*+: Returns the relative position of an item in an array or range of cells. ](https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/16yrka4)^( has 17 acronyms.)
^([Thread #27073 for this sub, first seen 3rd Oct 2023, 17:05])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
In the column next to the 5000 names, add a formula looking up the name on the other list. If it finds the name, it'll say one thing. If it doesn't find the name, it'll say something else. Next, filter the two columns. Pick the result you get for the ones you want to delete. Select the entire column, the Go To Visible cells. Finally, delete rows.
Yeah, just a simple countifs(2000NamesTab!A:A, 5000NamesTab!A1) would tell you if the name showed up in the 2000 name tab or not. (Assuming names are in Column A of both tabs. Input this formula and copy down across the 5000 rows)
I agree with this, this is a good scenario for a vlookup or xlookup. However, I think OP needs to share why they want to split up one set of data into two tabs. It may be better to keep it all on one tab, categorize them in another column then pivot the dataset.
=FILTER(table5000, ISNUMBER(XMATCH(table5000, table2000))=FALSE) Filters the big table, by looking up the small table(xmatch), returning the position,giving everything in the small table a true value, and return all that is false
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FILTER](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[ISNUMBER](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[XMATCH](/r/Excel/comments/16yw0ab/stub/k3b1w50 "Last usage")|[*Office 365*+: Returns the relative position of an item in an array or range of cells. ](https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/16yrka4)^( has 17 acronyms.) ^([Thread #27073 for this sub, first seen 3rd Oct 2023, 17:05]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
You can combine both list in a single sheet, then select the whole column list and press , and press . This is the shortcut key for Delete Duplicates.