Forum Discussion
Create sequence numbers based off of dates and IDs
Hi, I am looking for some help. I am looking to insert a column with a formula in my sheet of employees to provide the sequence number of dates for employee records from most current to oldest. Th...
In D2:
=COUNTIFS($A$2:$A$1000,$A2,$C$2:$C$1000,">="&$C2)
Adjust the ranges if you have more than 1000 rows of data
Fill down.