printing Hi, I am having trouble with printing.I do not know how to print page number 2 out of 5 pages in 1 worksheet of 1 workbook.Basically the question is ''print page number2 in the entire worksheet and the material is consisted of 5 pages.''Please send me answer.Thanks. ... 4 Feb 2010 19:08 printing tHi.I am having trouble with choosing the pages and printing them.Basically the question is '' print out page number 2 only out of 5 pages''?in one worksheet the material is consisted of 1 worksheet of 1 workbook.If anybody can help me.Thanks. ... 4 Feb 2010 19:08 simple countif formula Column B in my spreadsheet consists of 10 rows with one letter in each cell. I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value in each of those cells is "H". I have tried a simple formula like this =countif(B1,B3,B5,B7,B9,"H") but it does not work. Thanks for your help with this form... 4 Feb 2010 18:00 Transfering a changing cell value progressively through a work I tried this and what I get in the cell that I enter PrevSheet(Q7)what shows up in the cell is #REF!. I have been unable to make this produce a value. What did I do wrong? I copied the UDF to vis basic like you discribed in the previous email but there must be something that I did wrong. Thanks Mike -- ... 5 Feb 2010 13:58 if is error then "No Data", if not then average range I believe the formula should be something like: iferror(average(C1:F1=TRUE,"No Data), average(C1:F1) ... 4 Feb 2010 16:52 Calculations in filtered columns Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks ... 5 Feb 2010 19:35 Value list i need help with making value lists in excel so that i can make my data base consistant with the data i am entering ... 4 Feb 2010 15:44 edit a comment while protect sheet is on the cell is unprotected i want other useres to b able to enter /edit a comment in an unprotected cell when protect sheet is on ... 4 Feb 2010 15:44 How do I force the y-intercept value Is it possible to force the Y-intercept value to 100 when performing linear regression? ... 4 Feb 2010 13:29 Turning =E13 to =\$E\$13 I have worksheet with several hundred formulas in the form of =E13. I want to make all the formulas static, i.e. =\$E\$13, because I have to delete some rows and I don't want the formulas to automatically update to accomodate the missing rows. Is there a way to do this in one fell swoop rather than having to c... 4 Feb 2010 14:37