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...
Let's say your data is in A1:B13. You can use UNIQUE to return rows only appearing once.
=UNIQUE(A1:B13,,1)
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?