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...
You've already received a solution if you can apply the UNIQUE function. If you don't have Office365 or Excel 2021 you can try this:
=SUMPRODUCT(($A$1:$A$17=$A1)*(COUNTIFS($A$1:$A$17,$A1,$B$1:$B$17,$B1)=1))>0You can apply this rule if you want to conditionally format the values.
=IF(SUMPRODUCT(($A$1:$A$17=A1)*(COUNTIFS($A$1:$A$17,A1,$B$1:$B$17,B1)=1))>0,"True","")This formula returns "true" in column D if there is a unique number in the set.