I have two tables (Table2 and Table3), both with multiple columns but for the purpose of this let’s just say each has 3 columns, 'Date', 'Person' and 'Pass/Fail'.
Each person could appear in one or both of the tables, but the dates will be different in each. I need to return the highest date for a given person (named in cell A1) and where "Pass" is in the Pass/Fail column irrespective of which table they are in.
I have sussed this using MAXIFS for a single table, but I can't make it work across the second table.
If anyone has any suggestions, I would be most grateful.
Thanks in advance.
Each person could appear in one or both of the tables, but the dates will be different in each. I need to return the highest date for a given person (named in cell A1) and where "Pass" is in the Pass/Fail column irrespective of which table they are in.
I have sussed this using MAXIFS for a single table, but I can't make it work across the second table.
If anyone has any suggestions, I would be most grateful.
Thanks in advance.