This post is from a low-reputation account and contains an unverified outbound link. Be cautious before clicking external links.
Uses the countif function in excel to find duplicate cells except first one. The formula is =COUNTIF(A$1:A1,A1)>1
If the countif function returns a number greater than one then it means the value is duplicate and the value of the cell will be set to true.