WakeWorld

WakeWorld (http://www.wakeworld.com/forum/index.php)
-   Non-Wakeboarding Discussion (http://www.wakeworld.com/forum/forumdisplay.php?f=4387)
-   -   EXCEL Help (http://www.wakeworld.com/forum/showthread.php?t=791072)

depswa 12-07-2011 10:24 AM

EXCEL Help
 
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!

sidekicknicholas 12-07-2011 10:52 AM

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.

sidekicknicholas 12-07-2011 10:56 AM

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)

depswa 12-07-2011 1:45 PM

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/

clb 12-07-2011 3:07 PM

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

Save the file then F9 to recalc.

jeff_mn 12-14-2011 8:55 AM

Quote:

Originally Posted by clb (Post 1720803)
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

Save the file then F9 to recalc.

this


All times are GMT -7. The time now is 2:36 AM.