Check if duplicate in Numbers for Mac

Add a blank column to the right of the column you what to check, add this Formula to the whole column:

COUNTIF(A$1:A2;A2)

Leave a Reply

Your email address will not be published. Required fields are marked *