I need a formula that can find the last occurrence of each item in a list.
Scenario:
Column A(Products) Column B(Date of Arrival)
Socks————————————Sept 2
Shoes————————————Sept 3
Hats————————————–Sept 3
Shoes————————————Sept 4
Shoes————————————
Shirts————————————–
I need to get via excel formula, the latest Date of arrival per item say Sept 2 for “Socks”, Sept 3 for “Hats”, and Sept 4 for “Shoes”. Please note that “Shoes” here has 2 Date of Arrivals as compared to “Socks” and “Hats” that have only one Date of Arrival for each. If you will notice, “Shoes” is listed 3 times wherein the last one has blank Date of Arrival. Also, “Shirts” is listed but it has blank Date of Arrival. I need then a formula that will return the desired latest Date of arrivals as I indicated above and will just return blank for the “Shirts” since it has no Date of Arrival. To summarize the desired result:
Product Latest Date of Arrival
Socks———————-Sept 2
Shoes———————-Sept 4
Hats————————Sept 3
Shirts———————-[Blank]
Please help. Thanks. .