Nullifying Repeated Numbers in a Column

CVKing

I have one column that has the same value repeated thousands of times, and the data samples can be hundreds of thousands of rows. I am trying to make all of the repeated values in one column null, while keeping the rest of the row. I have tried using multi row with the following formulas without success, as they only nullify every other row. 

'If ([Row-1:Column Name] = [2Column Name]) then Null() Else [Column Name] endif'

and

'If ([Row-1:Column Name] != [Column Name]) then [Column Name] Else Null() endif'

How can I nullify thousands of repeated values in a column?

Screenshot 2024-10-28 095624.png

nickmartella

I think you would need to add a sort tool before the multi row formula - sort by the column you want to nullify repeated values, then add the multirow formula like this:

If [Row-1:ColumnName] = [ColumnName] Then Null() Else [ColumnName] Endif