•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Help would be very much appreciated on finding and locating duplicate values
Our take
Struggling to sift through thousands of ID numbers can be frustrating, especially when you need to identify duplicates across two extensive lists. Fortunately, there’s a straightforward solution that can help you efficiently find and align those matching entries. By leveraging a combination of classic Excel functions, you can highlight duplicates and organize them in a way that keeps your data clean and accessible. Keep reading to discover step-by-step guidance that will streamline your workflow and eliminate the headache of manual searching.
So essentially heres my problem. I have a list of 3,000 ID numbers in spaces say B2:B3,000 and a list of 9,000 ID numbers which are in say C2:C9,000. There are some of the ID numbers which appear in the first list which also appear in the second list, what I need help with is getting a function of sorts or something which will allow me to find all the ID numbers which appear in both lists and then bring them each to the top of the lists while also ensuring the two duplicates are in the same row. Also I will add that the version of excel which I am using does not have xlookup. Any help would be incredibly appreciated
[link] [comments]
Read on the original site
Open the publisher's page for the full experience