General

how do I create a trend formula with range that changes
I created a trend formula that works, but I want to make the range change as I add more columns to the source data. Here is an example: TREND(B3:X3,B1:X1,Y1,TRUE) row 3 contains the raw data (cells B3 - X3) row 1 contains the refrence which is 1 -23 Now I'd run a new raw report and the data would extend t... 25 Jan 2006 17:58

statistical data, stdev, Pp& Ppk
Hi All I need a bit of help with a (I think) complicated excel problem. I am using excel to help keep track of process capability studies (Checking the capability of a manufacturing process for those that don't know) What I have is a drawing dimmension (in this case a diameter) that I have to measure 30 samp... 25 Jan 2006 10:05

ticky box or no ticky box?
hi i being looking around on excel for a bit to try and find if i can place 'ticky boxs' in an excel cell. i know access can but can excel as have 'ticky boxs' or not? thanks johnny -- johnny.exe ------------------------------------------------------------------------ johnny.exe's Profile: http://www.excelforum.... 26 Jan 2006 05:17

Excel graph problem
Hi, I encountered a small problem while drawing a graph with Excel 2003. I entered X axis and Y axis value and plotted the graph and drawn the trend line with zero intercept and found the R (regression)square value. In the same graph If I entered X axis with some units (say grams), the R square value is reduc... 8 Feb 2006 05:09

Please Help
I am trying to open an excel document and it is says that I can only open as read only because it is locked for editing by user XXXXXX. The problem is the user who it says has it locked is myself and I don't have it opened at all. Can anyone help me with this??? ... 23 Jan 2006 12:41

Forumla Help
Need some help. I have forecasted sales, actual sales and % variance. The forumla I have currently is: =IF(B38=0,"",B38/B4). I need it to show the following: if forecasted amount is o and actual is greater than 1.00 it should read "unplanned sales". If actual is 0 and Forecast is greater than 1 I need it to read... 27 Jan 2006 19:16

Require Tmplwiz.exe for Excel 2003
Tmplwiz.exe for Excel 2002 does not seem to work for Excel 2003. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link ... 18 Jan 2006 18:08

shade hidden rows
How can I set up my worksheets so that rows that are hidden will be shaded in if they are unhidden? ... 18 Jan 2006 21:45

Need formula to calculate hours worked
Hi There, I have just created a schedule spreadsheet, does anybody know a formula that will allow me to add up the hours an employee has worked each week based on the shift times written in the cell for each day. e.g. cell A1 is "09.00-18.00" which equals 8 hours work, cell B2 is "08.00-20.00" which equals 11 ho... 31 Jan 2006 12:54

Charting Question
I have a table of data which I create a scatter graph to show the points. Is there an easy way to add labels through VBA? For eaxample if I have the data below in a spreadsheet and I want column B to be the X-axis and column C to be the Y-axis how can I easily/automatically add the text in column A as the data ... 18 Jan 2006 17:37