Articles
   
       
Pics/Video
       
Wake 101
   
       
       
Shop
Search
 
 
 
 
 
Home   Articles   Pics/Video   Gear   Wake 101   Events   Community   Forums   Classifieds   Contests   Shop   Search
WakeWorld Home
Email Password
Go Back   WakeWorld > Non-Wakeboarding Discussion

Share 
Reply
 
Thread Tools Display Modes
Old     (depswa)      Join Date: Nov 2000       12-07-2011, 10:24 AM Reply   
Does anyone know how I can have a cell within a worksheet show the same info that's on the tab for that pageautomatically? SO...let's say there is a tab for each day that is labeled with the date...within the worksheet I want a cell to show the same value. I know how to have cells show the same info as another cell (ex. =B2) or whatever...but how do I do it for a tab? =TABX? or something?

Also, if I have a list of names in a column. How can I do a count of how many nanes are in that column? I know how to do it if there are numerical values in a cell [ex. =COUNT(B2::B17], but that doesn't work for Alphabetical lists.

Thanks for your help!
Old     (sidekicknicholas)      Join Date: Mar 2007       12-07-2011, 10:52 AM Reply   
Quote:
Also, if I have a list of names in a column. How can I do a count of how many nanes are in that column?
If all of you names are in colum "A" lets say.... simple click the header of the colum (where it says "A") and in the lower right corner of the screen (just to the left of zoom) there will be a little dialog note that says "COUNT: #"

If you want that value to be posted in your sheet to a cell and update when things are added subtracted:
=COUNTA(A:A) * A:A would be for colum "A" .... change this to whatever you're using.
Old     (sidekicknicholas)      Join Date: Mar 2007       12-07-2011, 10:56 AM Reply   
Quote:
Does anyone know how I can have a cell within a worksheet show the same info that's on the tab for that pageautomatically?
Not exactly sure what you're asking here..... you want cells to display the name of tabs?

or


infomation in other tabs? ... for this lets say you're entering names into colum "A" .... starting with A1 and you would like those names to also display on Sheet 3 starting at B5....

On sheet 3 simple, B5, simple enter "=" then go to sheet 1, click A1, and enter.... not A1 from sheet 1 will display in B5 of sheet 3.

... lets say your first sheet is named MYFIRSTSHEET , and you want that info in MYFIRSTSHEET A1 to display on MYTHIRDSHEET starting at B5..... go to B5, enter "=MYFIRSTSHEET!A1" and that will also work **** Note: you need the sheet name EXACTLY correct ****

Once it is entered then just grab the little black box and you can drag this function left/right/up/down to populate other cells from that function (assuming you're going the same way as the sheet/cells you're getting your initial info from)

Last edited by sidekicknicholas; 12-07-2011 at 11:06 AM.
Old     (depswa)      Join Date: Nov 2000       12-07-2011, 1:45 PM Reply   
Nick...Awesome...thanks! Didn't know about "=COUNTA(A1:A15)" or whatever...

FOr the other one...I'm probably just being lazy, but I want to label the tab for the worksheet 12-7-11...then have a header on the sheet that pulls exactly whats on the tab into the worksheet...like this. http://imageshack.us/photo/my-images/28/exampleg.jpg/
Old     (clb)      Join Date: Dec 2007       12-07-2011, 3:07 PM Reply   
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Save the file then F9 to recalc.
Old     (jeff_mn)      Join Date: Jul 2009       12-14-2011, 8:55 AM Reply   
Quote:
Originally Posted by clb View Post
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Save the file then F9 to recalc.
this

Reply
Share 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



All times are GMT -7. The time now is 7:26 PM.

Home   Articles   Pics/Video   Gear   Wake 101   Events   Community   Forums   Classifieds   Contests   Shop   Search
Wake World Home

 

© 2019 eWake, Inc.    
Advertise    |    Contact    |    Terms of Use    |    Privacy Policy    |    Report Abuse    |    Conduct    |    About Us