I concatenated all the columns then used this formula to identify the unique values.
Formula:
=IF(COUNTIF($M$2:$M2,M2)=1,1,"")
I concatenated all the columns then used this formula to identify the unique values.
Formula:
=IF(COUNTIF($M$2:$M2,M2)=1,1,"")
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks