I have a list of vehicles dispatched by date and time. Columns ar
labeled date, time, vehicle id, origin and destination. I want t
list/filter the vehicles that have no entries for the last seven day
but only want the most recent record (older than seven days) and I wan
the entire row so I know where the vehicle was last. I can custo
filter for a date range that is less than a given variable but can'
figure out how write the IF to drop those record that have a mor
recent date entry

--
Message posted from http://www.ExcelForum.com