=COUNTIF(A:A,A1)-1
gives 1 if content in A1 is duplicated in Column A
and 2 if content in A1 is triplicated in Column A

Regards,
Stefi

€žNitin Kapoor€� ezt Ã*rta:

Hello Friends,

I want to change the duplicate as well as triplicate entries in a table
having some codes with the help of some excel formula....i want to assign 1
at the end of code if it is a duplicate entry and 2 at the end of code if it
is a triplicate entry..

how to do that..