1 min readfrom 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

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

submitted by /u/GreenBagger28
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#row zero
#financial modeling with spreadsheets
#ID numbers
#Excel
#duplicate values
#function
#list
#lookup
#Rows
#find
#top of the lists
#same row
#function of sorts
#B2:B3000
#C2:C9000
#help
#3,000 ID numbers