I've got a large amount of data that I need to analyse. Two of the columns contain values that I need to check for duplicates that will look something like this:
1 A 1 B 1 A 2 A 2 B 2 B 3 C 3 C 3 C 3 A
So the formula run across two columns would ideally spit out:
1 A 1 B 2 A 2 B 3 A 3 C
I've been using the following to extract duplicates from a single column, but am lost when it comes to looking at two columns.
Unfortunately I want to avoid manipulating the reference data, so it really makes things difficult. I'm thinking of concatenating the two columns and checking that singular column for dupes, but I feel like there's got to be a better way and suspect that doing that may also cause issues down the road.