Combining formulas
perhaps you should replace {1,2,3,4,5,6,7,8,9}
with {1;2;3;4;5;6;7;8;9}
"Charabeuh" a écrit dans le message de groupe de
discussion : ...
Hello,
You found the way to correct the formula :
It is to maintain ROW(1:9) as a contant array.
1) the first way is to replace ROW(1:9)
with {1,2,3,4,5,6,7,8,9}
2) another way is to replace ROW(1:9)
with ROW($1:$9)
Does this correct the problem ?
|