Hello all... it's been a while since I've been on here.
I have a formula in a column that checks to see if a value in another column is unique. It puts 1 if it's the first time it's seen it, and 0 if it isn't unique. Here is the formula:
=IF(COUNTIFS($A$2:$A2,A2)=1,1,0)
That same logic is...