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


--
zen_zen
------------------------------------------------------------------------
zen_zen's Profile: http://www.excelforum.com/member.php...o&userid=37436
View this thread: http://www.excelforum.com/showthread...hreadid=571073

Not completely sure what you're asking for but..............

Add some $ signs to make the cell references absolute.

=CORREL(IGR!$C$233:$C$262,IIA!$C$233:$C$262)

Select the cell and F2 to edit.

Highlight the cell refs in the formula bar and hit F4 key to cycle through your
options.


Gord Dibben MS Excel MVP


On Sat, 12 Aug 2006 15:29:09 -0400, zen_zen
<(E-Mail Removed)> wrote:

>
>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