Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 05 December 2019
  0 Replies
  1.6K 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.