I have a list of spare part repairs. Column A Repair date, Column B Part reference, Column C repair information. The same Part reference can appear in the list at subsequent repair dates.
How would I look up the array and return the latest date repair information from Column C.
Help appreciated
M
ps dummy file attached for clarification. Red text is the wanted result.
Bookmarks