Log in  \/ 
x
or
x
x
Register  \/ 
x

or

unanswered Flag duplicates with respect to dates

More
4 months 1 day ago #1951 by kalaiarasan18
Flag duplicates with respect to dates was created by kalaiarasan18
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

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun