Forum Discussion
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...
I have taken another look at the problem and would note that no values have actually been filtered from the dataset. Broadly speaking a simple top to bottom sort on datetime will give you the sequence you require. Conditional formatting could be used so that the first instance only is shown for any given timeslot and borders are shown between timeslots.
Of course, I would use SORTBY whereas you are stuck with either a manual process or cumbersome ranking and lookup functions.