FILTER FUNCTION multiple IFs as DYNAMIC RANGE spill? XL2021

[vletm]

As I can only guess - what?
# You saw only 'search' case ...

# but You just expected to see also all data as below.
Why do You would like to see two times same information? Isn't one time enough?

I had to 'clean' some of those datas; which has times (seconds) or calculated values (decimals).
If some min-max -option would like to have then ... that would be possible too.
Question: 0-62 in seconds.
If that something ... how long time takes from traffic lights or what?

 

[MikeVol]

I've been following your topics (not intentionally) and I see that with your potential, you could solve your own problems. Or maybe you're just trying to show off. Your topics are convoluted and overlap with your other topics, hence the reluctance to help anyone.

 

[Stephan]

I've been following your topics (not intentionally) and I see that with your potential, you could solve your own problems. Or maybe you're just trying to show off. Your topics are convoluted and overlap with your other topics, hence the reluctance to help anyone.

No not really! Answers bring more questions don't they.

Formulas are in vast abundance, is something far from mastered. Knowing of solutions is handy ain't it.

XL is vast, there is lots to learn.

When you're in a hurry & cornered for a quick response ain't it nice to have a template for it.

XL Training Providers do a great job, there is lots of example, but generally you notice of possible situations you have no idea to do.

Which is why I ask on Forums.

After Googling away, some times, you find the answer, others u don't.

Mastering XL for every Formula, Function etc is something I can easily say not a chance, hence question after another..

Sorry boring you. But at least I upload the final version, most ppl just say... Done it, cheers.

Well would have been nice to see a working workbook... Nevermind.