Hello everyone!
I urgently need help with the file i'm working on. I'm just a newbie in excel and I will appreciate sharing your expertise.
I'd like to fill E4 of the closest date and time from the list in Column A considering the given criteria in cells E1 and E2.(Please see attached file)
I'm trying to play with INDEX and MATCH array formula but I'm not getting my desired result.
Please help.
You can use an array formula like this:
=INDEX($A$2:$A$12,MATCH(MIN(IF($B$2:$B$12=$E$1,ABS($A$2:$A$12-$E$2))),IF($B$2:$B$12=$E$1,ABS($A$2:$A$12-$E$2)),0))
but first of all you need to convert your data into actual date/time values rather than the text theya re currently. See attached version of your workbook.
how can I make it 'prior to closest' ? Thanx in advance
