Hello, guys
I'm new to the forum, so I apologise in advance if this is not an appropriate question.
Well, I have a spreadsheet with several columns (months from jan/2018 to dec/2020), the data in each column are unique IDs that I compiled using spreadsheets that I receive monthly (avarage 300k rows/month). I need to know which IDs are present in every column, from jan/2018 to dec/2020.
The data attached was generated by me as an example that I think suffices to give an understanding of the problem. If not, let me know. I really need help with this one.
The IDs 0000009 to 0000019 are the only ones that appear in every single column, I highlighted it in red. The ID 0000002 is duplicate only in the first two columns.
Bookmarks