liabilityquek
Member
Hi All,
I have a set of invoice numbers which has rejected dates, processing dates, approving dates and paid dates. I have used MAX function to identify the latest date for each particular invoice. However, i would like to identify each status of each invoices; ie rejected, processing, approved or paid based on the latest dates. These are all classified as Table 1.
And also, i would like to vlookup a list of invoice numbers on the latest dates and status from Table 1. However, there are duplicate invoices and would like to find out what is the latest date and status.
Attached is the excel file for your reference.
Thank you for the assistance.
I have a set of invoice numbers which has rejected dates, processing dates, approving dates and paid dates. I have used MAX function to identify the latest date for each particular invoice. However, i would like to identify each status of each invoices; ie rejected, processing, approved or paid based on the latest dates. These are all classified as Table 1.
And also, i would like to vlookup a list of invoice numbers on the latest dates and status from Table 1. However, there are duplicate invoices and would like to find out what is the latest date and status.
Attached is the excel file for your reference.
Thank you for the assistance.