Forum Discussion
What do you think of thunks?
OK, so the most likely response by far is going to be "I don't". However, I tried one of Omid Motamedisedeh's regular challenges and found it a suitable problem for exploring some of the lesser k...
This thread is mainly to illustrate technique, not to solve concrete task. However. Perhaps I missed something, but all solutions take 2 records back and 2 records forward for the range. Not dates. What if we take the range for dates (assuming they are not sequential and some could be missed), i.e. [Date] -2, not two records back ?
I would think Daniel's approach could be easily adapted to that:
=FILTER(C3:D25,MAP(C3:C25,LAMBDA(x,AND(XLOOKUP(x,C3:C25,D3:D25)>N(FILTER(D3:D25,(x-2<C3:C25)*(x+2>C3:C25),0)))))))