Hi there,
I'm searching for a formula which will return me the value in column C which goes with two criteria: (1) column A reads 'John' and (2) the highest date in column B. So the outcome would be 'fish' in the attached xls.
Would appreciate if someone coule help me.
Thanks,
Niels
Bookmarks