Find and identify duplicates for unsorted data
Fairly new to JMP, so my knowledge of how to use formulas is pretty limited. If I have a column of values (character) and I want to identify them as duplicates in a different column, what formula would I use? (My data has 10 columns already sorted by a different column's values) In the past, I have used the formula below (when the data that needs duplicates identified has been sorted alphabeti...