1

Topic: Re: to hang up an ex-fur-tree

Hello, Kodt, you wrote: Cast https://pikabu.ru/story/exel_veshaet_nout_5801336 What maximum computing complexity it is possible to organize on ? ("From a box", without macroes) If at us is N cells with formulas what most fierce update is possible at change of value of one cell? Exponential A1=a A2= (A1; "a"; "aa") A2... To fill downwards (Ctrl+D) the Linear complexity: each following cell depends on a constant amount of the previous. Square: depends on all previous (for example, the total on a column above). By the way, whether and the ex-fur-tree recognizes such formulas and whether  the total? Who is more?

2

Re: Re: to hang up an ex-fur-tree

Hello, Kodt, you wrote: And whether there are any scenarios, more  over numbers? It is possible excel to make more "interactive" adding in each calculation loaded SEARCH ("1"; REPETITION ("0"; 32766) and "1") - SEARCH ("2"; REPETITION ("0"; 32766) and "2") For example A1=1 A2=A1 + (SEARCH ("1"; REPETITION ("0"; 32766) and "1") - SEARCH ("2"; REPETITION ("0"; 32766) and "2")) B2=A1 + (SEARCH ("1"; REPETITION ("0"; 32766) and "1") - SEARCH ("2"; REPETITION ("0"; 32766) and "2")) And then to expand to the right both to expand downwards. And to change A1. It will be visible in what order considers. Sinkers can be added at once groups on some pieces if it is not enough of one.