0
Undo
Votes
Hi,
I need to flag 1st duplicate and 2nd duplicate till nth duplicate with respect to date.
for ex: 01/01/2010 is having data with duplicates and using COUNTIF it can return 1st duplicate and then 02/01/2020 is having same data and I need to flag second duplicate vice versa.
I am using below formula
"{=IF(COUNTIF($A$3:A3,A3)>1,"NX","X")}
here "X" return with 1st duplicate value
I need to flag 1st duplicate and 2nd duplicate till nth duplicate with respect to date.
for ex: 01/01/2010 is having data with duplicates and using COUNTIF it can return 1st duplicate and then 02/01/2020 is having same data and I need to flag second duplicate vice versa.
I am using below formula
"{=IF(COUNTIF($A$3:A3,A3)>1,"NX","X")}
here "X" return with 1st duplicate value
There are no replies made for this post yet.