Hi,

I have a large data table with a column including text in each row. Some cell values occure multiple times in the column, others don't.

Is it possible to have a formula next to this column which returns a value (let's say "ORIGINAL") next to the first occurrence, and a separate value (let's say "DUPLICATE") next to a cell if a matching value already occurred before it (i.e. it's a duplicate).

If a value only has one occurance, it can say "ORIGNAL"

Thank you!