Hi,
Take one example,
for i in {B..U}
do
echo -n "=PEARSON(B2:B43,$i 2:$i 43) "
done
$i2 not work, $i 2 added extra space,
are there someway to handle the $i2 situation?
Thanks with best regards,
P.S Output
=PEARSON(B2:B43,B 2:B 43) =PEARSON(B2:B43,C 2:C 43)
expected one
=PEARSON(B2:B43,B2:B43) =PEARSON(B2:B43,C2:C43)