Y Yoshi Tucker Oct 3, 2003 #1 How can I enter arguments as ranges like A1:A100,B1:B100? I need your help because I have several arrays to deal with.
How can I enter arguments as ranges like A1:A100,B1:B100? I need your help because I have several arrays to deal with.
B Bernard Liengme Oct 3, 2003 #2 Yoshi, You either type them (no need to bother to capitalize column letters) =CORREL(A1:A100, B1:B100) Or type =CORREL( and drag mouse over A1:A100, type , drag mouse over B1:B100, type ) Or click on Function Wizard, fill in form Bernard
Yoshi, You either type them (no need to bother to capitalize column letters) =CORREL(A1:A100, B1:B100) Or type =CORREL( and drag mouse over A1:A100, type , drag mouse over B1:B100, type ) Or click on Function Wizard, fill in form Bernard