Hi,
I have a workbook where I am looking to consolidate rows where a business appears more than once. I am looking to obtain a single view of the business with the status of the business updated with the last status (the workbook contains all business statuses and when they were updated with a date.).
Ideally I would like to see the record appear once with the last status and the last status date.
If you need to see the workbook, please let me know and I can attach an example. I suspect it is a match or vlookup function.
Thanks guys.
I have a workbook where I am looking to consolidate rows where a business appears more than once. I am looking to obtain a single view of the business with the status of the business updated with the last status (the workbook contains all business statuses and when they were updated with a date.).
Ideally I would like to see the record appear once with the last status and the last status date.
If you need to see the workbook, please let me know and I can attach an example. I suspect it is a match or vlookup function.
Thanks guys.
