what is the quickest way to multiply the rows by coloums. Without manually having to change the formula in each row.
e.g I first typed the formula =CORREL($B$2:$B$9,B2:B9) in cell C15 then dragged it across.
Then for cell C16 I had to type the formula =CORREL($C$2:$C$9,B2:B9) then dragged it across.
Can you please advise of a better and quicker way. Thanks.
Thanks
![]()


LinkBack URL
About LinkBacks
Reply With Quote
