I have a range of dates for items which expire. These items conditionally format to flag a colour:
Out of Date
Out of Date within 14 days
Out of Date within 28 days
I need to be able to look across the list of dates and put that date into Sheet 1, along with the persons name and the item which is expiring. I need to be able to do that for the three out of date options above, and this needs to be autonomous.
My problem is that I can return the first 'out of date' item, but when I want to look across this range again, I want to bypass the first date, because it has already been returned, and find the next out of date item.
Solved by C. L. in 18 mins