Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 05 December 2019
  0 Replies
  1.5K Visits
0
Votes
Undo
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
There are no replies made for this post yet.