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...
FlowEZ All you need to do is a custom sort. First on Load (ascending) then on Date/Time (ascending).
(Screenshot taken in Excel for Mac, but it's similar in the Windows version.)
RE-attaching your file with the sorting in it.