Answer for:

formula in excel that can find the last occurrence of each item in a list

Message 4 of 4

View entire thread
0 Votes

I followed your instructions but I am getting these results:

Socks 2-Sep Socks 2-Sep
Shoes 3-Sep Shoes 2-Sep
Hats 4-Sep Hats 2-Sep
Shoes 4-Sep Shirts #VALUE!
Shoes #VALUE!
Shirts #VALUE!
One thing I noticed is that, the formula consistently returns 2-Sep for all the products which should not be as they have different Dates of Arrival.... Please advise... Thanks a lot..