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-
|