i am currently using the correlation formula to test on a large set of data:
e.g.
CORREL(IGR!C233:C262,IIA!C233:C262)
IGR and IIA - they are a pair of data i place in 2 different worksheets, each has set of data, and I need to pull the data of C233 and C262 in IGR and IIA worksheet
and I have many pairs in different worksheets
E.G. RMR and RHR
so I copy the forumla above and hope can only manually adjust the symbol from IGR and IIA to RMR and RHR
when I copy it shift the number down
=CORREL(IGR!C242:[/B]C271,IIA!C242:C271)
from C233 to C242 and C 262 to C271 and I would have to manually adjust it back to C233 and C262
Since I have such a long list of data I need to do, I cannot manually adjust the number every single times
can anyone help or know a function so that I do not need to manually adjust it?
so every time when I copy and paste, it will show me
CORREL(IGR!C233:C262,IIA!C233:C262)
again instead of shifting the number down
many thanks
Bookmarks