Hi all having a bit of a dilemma.
I need to make 3 formulas in this sheet to populate the rejected dates in column I from past 6 days in another tab, valid dates in column J from past 6 days in the other tab N,P,R, and then populate the IDs in column A for the dates that have populated in columns I and J. The issue is for the rejected dates in the London tab there can be up to 3 dates in columns N, P and R depending how many times it failed the compliance check, so it would need to be the last date found. I have no idea how to work it all out, any help would be very much appreciated. All the other columns are simple lookups which i've done. Thanks
Have attached the sheet also.
Bookmarks