Forum Discussion
Number Duplicate Values (in Chronological Order) Based on DateTime Column
My first post! I am attempting to build a formula in Excel which will count the number of duplicates in the [Load ID] column while respecting the chronological order in the [Tender Request Creati...
I would like to suggest two different formula, one is finding the duplicates & another shows the frequency of the duplicates.
=IF(COUNTIF(A:A,A2)>1,"Duplicate",COUNTIF(A:A,A2))
=COUNTIF($A$2:$A$10236,A2)
- Adjust cell references in the formula as needed.