function without recursion

[Edcronos]

Hello,
I'm still tangled with the macro filtering formula,
I can only take the formula to the 3rd level

then I thought of using separate functions and internal calls between each other
but has the problem of recursion

Its a function work without recursion, as if it were a completely new?
functionA(functionA())
that the internal mode is executed before the outer
but the way I imagined, I must make an internal call

 

[Hui]

Can you post the problem that this relates to?

There may be other solutions that users maybe aware of

 

[Marc L]

Hi !

Like my samples in your previous thread, for this​

I used only one call of a single function just following this idea :
« when several delimiters are in a string,
it's so easy to mod it with only one delimiter to parse data ! » …

If there is a sub level to parse, a recursive function is often much more easier.
When I tried to make a JSON data decoder with object model
(other way than an easy Split process working too with JSON),
a non recursive way was too complex, tricky and endless …
Solved in a few minutes with a recursive process !

So no need to create a duplicate post !
Just think, use a paper and a pen to organize it.
Come back with a clear explanation and an attachment
with true source data and expected results
'cause again your initial post is falling from darkness …
______________________________________________________________
If you can’t explain it simply, you don’t understand it well enough … (Albert Einstein)​

 

[Edcronos]

Sorry, perhaps the online translator is not enough.

My problem is no longer separate the formula
It is to do the filtering without losing the dependence of external functions

=And(OR((($A$1="X";$A$1="C";$A$1="B";$A$1="L");OR(((T100=$C$1:$C$3);OR(((And(OR(($A$1="X";$A$1="L");OR((S100=$B$1:$B$3;U100=$B$1:$B$3));And(OR(($A$1="X";$A$1="B");OR((COUNTIFS(IF(T99<>"";S99:U99;IF(T98<>"";S98:U98;IF(T97<>"";S97:U97;IF(T96<>"";S96:U96;IF(T95<>"";S95:U95;S95:U95)))));$B$1:$B$3)));And(OR((($A$1="X";$A$1="C");OR(((COUNTIF(IF(T101<>"";S101:U101;IF(T102<>"";S102:U102;IF(T103<>"";S103:U103;IF(T104<>"";S104:U104;IF(T105<>"";S105:U105;S105:U105)))));$B$1:$B$3)))))

course I will not use formulas so to filter
but as you can see this formula has several levels and the result of it depends on several factors
the macro that does the filtering means I only got to go to the 3rd level without complicating too

If not possible, I will use Static arrays to go keeping the levels and values,
just that it will spend extra memory and processing time