Forum Discussion

Copper Contributor

Dec 20, 2021

search for a solution that can replace the FILTR function

Hello Everyone, I am writing to you today, so that I can share with you my Excel problem, which I have been meeting with for a few days. Indeed, I want the Excel table to search for references bas...

Bronze Contributor

Dec 28, 2021

can you share your workbook?

Miiryam
Copper Contributor
Jan 03, 2022
Yea_So
Thank you for your response.
There my workbook !
Nouveau Plng Trsprt.xlsm117 KB
- Yea_So
  Bronze Contributor
  Jan 03, 2022
  Miiryam
  
  Does your work not give you a laptop to use if you have to bring work at home?
  - Miiryam
    Copper Contributor
    Jan 03, 2022
    Yea_So
    
    unfortunatly not, I've mine so I can use it at home.
    But for work I've just one fix in my office
- PeterBartholomew1
  Silver Contributor
  Jan 03, 2022
  Miiryam
  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.
  - Miiryam
    Copper Contributor
    Jan 03, 2022
    PeterBartholomew1
    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 !

Resources