Re: Find Common Numbers Between 2 Columns
Wow, who did you upset to get this job?
There will be a VBA solution, and I'm sure there'll be other threads on here to give you some ideas, BUT see attached for a not-very-elegant solution which might suit if this is a one-off or infrequent task.
Use Data > Text to Columns to split up the data.
Do a COUNTIF per each separated item to check for duplicates.
Concatenate all the resulting values.
Feels like there's a better way, but can't think of it right now.
Hmmmmmm....