Forum Discussion
Find unique values from two columns
This is my first time posting so bear with me. I need to be able to find only the cells that have a unique number in that set. For example, in the columns below I would only need to identify the ent...
Patrick2788 Thank you for the quick response. That worked beautifully except I forgot to add in my post that some of the entries will have a duplicate of one of the numbers like the example below. Sorry I thought I had enough of the range in the original post.
161252 13.1
161252 13.1
161252 13.1
161252 13.1
161252 13.1
161252 15.03
161252 15.03
The UNIQUE formula above would not return these. Are you looking to pull straight unique values from these?