Online since 2002. Over 3300 puzzles, 2600 worldwide members, and 270,000 messages.

TwistyPuzzles.com Forum

It is currently Wed Apr 23, 2014 10:04 pm

All times are UTC - 5 hours



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: little Excel problem
PostPosted: Sat May 14, 2011 8:13 am 
Offline
User avatar

Joined: Sun Apr 16, 2000 3:17 pm
Location: Hong Kong
Ok, I'm in need of help once again. I have an excel file that has a couple of pages on it. I need to run a Pearson's correlation on some numbers I have listed on page one, but I need the results on page 2.
Can anyone explain how to make the formula work????

I have a partner, but I don't want to look like the incompetent twat I am and ask her. Help please!

_________________
Rox's Rambling Blog
Katsmom's Puzzling Videos


Top
 Profile  
 
 Post subject: Re: little Excel problem
PostPosted: Sat May 14, 2011 8:16 am 
Offline
User avatar

Joined: Fri Feb 08, 2008 1:47 am
Location: near Utrecht, Netherlands
You can reference cells from another page by using =PageName!A1.

_________________
Tom's Shapeways Puzzle Shop - your order from my shop includes free stickers!
Tom's Puzzle Website


Buy my mass produced puzzles at Mefferts:
- 4x4x6 Cuboid for just $38
- Curvy Copter for just $18
- 3x4x5 Cuboid for just $34


Top
 Profile  
 
 Post subject: Re: little Excel problem
PostPosted: Sat May 14, 2011 9:52 am 
Offline
User avatar

Joined: Mon Oct 18, 2010 10:48 am
Or, when typing the formula in, click page 1 and select the cells on the other page with the mouse.

_________________
--Noah

I don't know half of you half as well as I should like and I like less than half of you half as well as you deserve.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Forum powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group