Forum Discussion
Miiryam
Dec 20, 2021Copper Contributor
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...
Yea_So
Jan 03, 2022Bronze Contributor
so filter works in excel online? Then you can copy/paste value after you put the formula in excel 365 online and have absolute values in the workbook after you save it.
- Yea_SoJan 03, 2022Bronze Contributor
Anyway the workbook you setup won't work because you only have 3 items for each time segment but some of your dataset exceeds the three limit per time slot:
I would surmise that power query is the only solution to your issue which you would need 365.
If you pointed this out to your employer, maybe they will upgrade their office to the 365 subscription since most if not all the data set involved in freight tracking such as your data set needs the feature functions that is only available in 365.