Get duplicate values in same column with iteration wise

Hi , I have a scenario where i have to find duplicated values with in a column and return 1 or 0 as a output Excel vlookup i have - +IF(ISERROR(VLOOKUP(AI2,$AI$1:AI1,1,0))=FALSE,0,1)  the duplic...