Hi all,
Got a problem I hope you can help with.
I have a sheet full of service dates for equipment (in a list). I need to apply a filter/macro or whatever would be best to generate a list of equipment that requires servicing. The problem is each equipment item may have more then one service date and I need it to focus on the most recent date for that item.
So it will then only pull from it the items that haven't been serviced in the last twelve months.
Attached is part of the list and as you can see some items have been serviced more then once, so I need it to focus on the most recent date.
Is this possible?
Thanks everyone.
Bookmarks