Forum Discussion
search for a solution that can replace the FILTR function
Excel 365 has a specific function intended for such filtering operations
= FILTER(Reference, (Date+Time)=(d+t))where the time 't' from the output table will need to be a relative reference. For me, using array formulas throughout, the main problem is not extracting the results; it is presenting them in the desired format.
A table with the times in a horizontal array and the 3 references below might be more easily achieved as an intermediate step.
Yeah, we can use this like a solution, but only for the 365 version.
But me I'm working by Excel 2016, and I've already use a VBA, and lot of formulas that they're not available in 365, so I can't use it.
Anyway, thank you for your help !- I had similar problems but decided I could no longer use 2010/2016! Mind you, my version of 365 is desktop rather than online so I still use VBA occasionally.
Yeah, I see, but the problem that i can't install the 365 in the desktop, because it's for work, so I should see with the IT (information technology) and I guess this is nearly impossible, that's why I'm searching for a formula that can replace it.
But, I think that it's not exicting.
I'll accept this as a solution.
There my workbook.