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...
As variant, to have filtered result as
formulas are
in E2:
=SORTBY( Tbl_TenderData[[Load ID]:[Tender Request Creation Date/Time]],
Tbl_TenderData[Load ID],1,
Tbl_TenderData[Tender Request Creation Date/Time],1
)
in G2:
=ROW(E2#)-ROW($E$1)-XMATCH(INDEX($E$2#,0,1),INDEX($E$2#,0,1))+1