I want to create a list which shows the latest date that someone sent me a message on Linked In. I have exported the data, in the following format, and there are multiple entries for individuals who have sent me messages in the past. I want to get the latest message date from each person.
I tried using a pivot table and I can get the count of messages but not the latest date. I tried the Max function hoping that would work but it didn’t. My issue is because I can’t predict how many people have sent a message so each record that needs to be checked is a different length. I need the Max Date for each different name.