How about something like this. I would suggest you create an unique ID field which is in column L.

1. I'm guessing you are saying, if the Transaction No. is blank, then that row should not be returned. The formula is in E16:E19 and everything to the left pulls from the unique ID in E16:E19.

2. You didn't say what the two criteria are.

3. Look in column K. Along with the formula I used a custom format. The formual returns the rank based on the Date Approved and the custom format fills in the 2018-

Attached Files

Sample Transactions (1).xlsx (13.6 KB, 11 views)

Thank you JeffryBrown. Column K was the clincher. Re the two criteria, I just added another IF in the formula that you suggested. But the sequence numbering in column K is quite odd, if I type the same date on two or more rows, the RANK formula throws serial numbers for these same rows with the largest number on the first row.. Like this...

Approval Date------------Number--------Could this be arranged into
Jan 3----------------------2018-04-------2018-02
Jan 2----------------------2018-01-------2018-01
Jan 3----------------------2018-03-------2018-03
Jan 3----------------------2018-02-------2018-04
Jan 5----------------------2018-06-------2018-05
Jan 5----------------------2018-05-------2018-06

Is there a way for the RANK formula to start the lower sequence number from the first row of the same dates?