Functions

Having info in a certain cell EXACTLY same as in cell on anoth
"Max" wrote: In your summary tab, place this in any starting cell, say in B2: =IF(ISBLANK(OFFSET(INDIRECT("'page1'!A1"),ROWS($1:1)-1,COLUMNS($A:A)-1)),"",OFFSET(INDIRECT("'page1'!A1"),ROWS($1:1)-1,COLUMNS($A:A)-1)) Copy B2 across by 16 cols, fill down by 30 rows to cover the extent of the "A1:P30" r... 27 May 2010 18:11

prompting while typing
Open office org - while working on excel sheet, prompting of words helps a lot in reducing the time of work. Is microsoft excel having the same function ... 27 May 2010 18:11

YTD % over 12 accumulating figures
I have a spreadsheet listing out employees, e.g. as follows: Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD% A N Other 1 0 0 0.5 5 0 0 0 0 0 0 0 6.5 F Smith 0 0 0 0 0 0 0 0 0 0 ... 27 May 2010 18:11

Macro to build table
I think I got it - can someone confirm this is accurate? Sub Macro() Dim lngRow As Long Dim intA As Integer, intB As Integer, intC As Integer, intD As Integer, intE As Integer, intF As Integer For intA = 1 To 2 For intB = 1 To 2 For intC = 1 To 2 For intD = 1 To 2 For intE = 1 To 2 For intF = 1 To 2 lngRo... 27 May 2010 17:05

If calculation
I am trying to do the following inputting in the same cell, 0 to 72=0 73 - 102 = whatever is input in the cell minus 72 over 102 = 30 ie 62 73 82 93 102 0 1 10 21 30 I have managed most of this with IFs, but not all. Does anyone have any ideas? ... 28 May 2010 05:00

If statement linking data from one sheet to another
Jacob: Thanks for the help, but it didn't work I get the #Ref error. "Jacob Skaria" wrote: Try =IF(I53>0,INDIRECT("'+Agency Reallocation data'!D" & I53),"") -- Jacob (MVP - Excel) "Mathew" wrote: I have a spreadsheet with many tabs. I am trying to develop a summery sheet ... 27 May 2010 17:05

How do I get to add up only the values > than 0?
How do I get to add up only the values > than 0? Only count: =((Q8)*0.5)+(Q8) .... if larger than 0 ... 27 May 2010 18:11

Picture protection
when we protect a sheet with a password, why a picture that we insert in sheet is not protected. Suresh ... 27 May 2010 19:18

Removing Special Characters
The clean function in Excel sorts this out perfectly. Lets say your string with these funny characters is in cell A5, then in the adjacent cell type =CLEAN(A5) and you'll get the string without the funny characters in there. It's brilliant and so simple. Kate -- digileaf -----------------------------... 27 May 2010 08:10

Date Math
Excel 2007 1 have a start date: 01/01/2009 finish date: 23/06/2010 I want to calculate the length of service between the two dates to the nearest month, eg (dates abaove) and return a string like so result = 1 year 6 months how can I do this? Thanks A ... 27 May 2010 18:11