I had the first part of this macro built last year but need to add another criteria to it. We were just matching on company name last time.
I have very basic customer list and need to consolidate the student name cell IF the company name, address, and refresher date cells are the same.
How it looks now (there are columns up to P with data):
How it needs to be (matched on company, address, AND refresher date):