Hi all I have the below formula
Worksheet 1
The column A contains the dates from oct to the end of the year, columns B - AP contain trucks and the destinations they went to on each date, Row 96 contains the last destination
Worksheet 2
Contains a table showing the last date and destination...