Say's cell or chart you are trying to change is protected and therefore read only how do fix or change this? -- Kelley

My worksheet has a number of columns. The second column is a sequence of month-ending dates that are one month apart. The 5th column has a series of values....

I need to make a flexible sum in an array( not a single column or row). Say: 1. sum range: B2:Z20 2. Criteria1 range: B1:Z1 Criteria 2 range: A2 A20 Any...

I have read over the several post regarding the adding of values on one sheet to provide it in a summery sheet but all efforts have failed to work it out....

Skeletor" wrote: I'm sorry to say, this didn't work. But I believe it is due to my lack of understanding, so i ahve a couple of questions; 1)When I...

I'm trying to find out the difference between two times, for example, In at 20:55 (8:55 PM) Out at 21:10 (9:10 PM) I know that if I substract 21:10 from...

I have an original list of addresses. A "reroute" list is provided. If columns A, B, & C on the original list match columns A, B, & C on the "reroute"...

Hi, I've tried creating a formula that will return the value "14" if true or "4" if false but i can't get in to work. *=IF(H23177!$A$1:$A$3=A1,"14","4"). ...

Hi Guys, Im trying to get a virtual clock in excel and found this prev answer from 11/17/2007 which apparently works but I unfortunately, dont know anything...

I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the...

Hi, I'm trying to prepare a summary worksheet to count where B2:B22 = "associate" and C2:C22 contains a date (or is not blank) I'm sure it's doable but I'm...

Hi all, This might be pretty a breeze for some. I am looking for ONE SINGLE formula that returns a row number where a supplied value is within minimum...

Some data was entered into an Excel worksheet after a cut off date. I there a way of telling when the data was entered.

I have been given a worksheet with links to several temporary files which no longer exist. I do not need the links. When I use tools, options, and...

Hi I have a table with headings in range A1:C1 and values in range A2:C10. I've applied a autofilter on the table. AMOUNT CURRENCY BT/FT 100 ...

Why does this formula not work? =IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1) NonWorkDays2008 is a defined name in another worksheet of the same...

Excel formula I need to sort or transfer the data entered into one sheet to automatically show on another sheet within the same workbook but depending on the...

I would like to get the average number on a specific range. I have B7:B172 with dates (from 01/01/08 to 25/08/08) sorted descending. I have D7:D172 with...

Is there a way to combine two formulas in adjecent cells into one single formula? It is important that the resulting cell contains the formula that is in...

I have a list as follows: timothy - 29 james - 32 brian - 41 I want to get rid of the "timothy - " so just "29" remains. I have tried Find and Replace using...