Distinct Function and creating a helper column

Jeremy Norman

Well, I am striking out. I want to create a helper column generated off the Distinct Formula. Basically, i want to place a 1 in a column if the [Base] Column is distinct to other entries.

=IF(DISTINCT(Base:Base), 1, 0) is my formula thought but i dont know exactly how to accomplish this.

Thanks for your help in advance!

Christian Graf

Try this:

=IF(COUNTIFS(Base:Base, Base@row) = 1, 1, 0)

Hope it helps.

Jeremy Norman

@Christian Graf Thanks for your help. Unfortunately, the formula only places Zeros in the column. It does not count any of the distinct bases.

Any other thoughts?

Christian Graf

@Jeremy Norman

Did you convert it to a column formula? It should work.

If you are only getting zeros, then those bases are not distinct values. They must have duplicates.

What value format are these "bases" are these numeric values, or character values?