I have been racking my brain to figure out why my formula is not working but now I see that when reviewing the results through the functional argument tool I...

Does anyone know how to Merge cells once you have protected a sheet? There is the option to 'allow users to format cells', but for some reason it will not...

I have collumn A as referece numbers such as 0535 which relate to several values in collumn D eg. 0535 £235 0535 £82 0535 ...

I would like to calculate how many months it has been from one cell to another. Example: cell a1 has 1/5/2009 and cell b1 has 5/17/2009. Is there a function...

I am using a ComboBox for a drop list. How can I increase rows in the box because i can only get it to show 121 rows? -- Chris

Problem- Problem- Excel not recognising or counting values between '0.01 to 0.99' in cells containing formula. Exact sheet can be downloaded at-...

Is it possible to retrieve values from a internet site. In particular I am looking at a price list which is changing regularly.:Bgr Thanks, W --

Hola q tal, como puedo hacer para que en una casilla desplegable eligiendo un mes me situe ordenadamente los dias y numeros del mes??

I keep getting the wrong result when I use =IF(G20=+-H20,"OK","PROBLEM"). I know the result should be "Problem" due to G20 being less than H20 -- Bushy

Hi, Very odd but on a spreadhseet that I have been using fora year, when I go to row 1 (my header row) the mouse pointer turns into a pointing finger. I cant...

I have a column that contains number/letter format 100ABC, 101DEF, etc. When I do a custom filter to show all the cells that contain 100, etc., the entire...

I'm wanted to build a formula that will do the following, CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count...

Cell A1 ~ Jan 1, 2009 Cell B1 ~ Basically, I want the cell to acknowledged that a day is equal to 8 hours. Can you help to figure out how can I do...

I have a column that contains number/letter format 100ABC, 101DEF, etc. When I do a custom filter to show all the cells that contain 100, etc., the entire...

hi im using excel 2003. How would i count the number of "Lates" for each individual. here is my data: sheet1: name Attendance karen late bryan ...

Cell A1 ~ 09:00 (Plan arrival time) Cell A2 ~ 09:15 (Actual Arrival Time) Cell A3 ~ 0:15 (Late by 15Min) The above tells the timing for arriving to work and...

Hello: I have a sheet like this: A B C D E F G H I 1 ...

I'm trying to check cells K5 or K6 or K7 or K8 or K9 for the presence of the letter "x" and if "True" to multiply cell H5 by the appropriate percentage and...

I have a rather large worksheet that has the same text in several columns on each page. How do I set up my spreadsheet so that when you enter the text on the...

Hello, Is there a way to retrieve range name if value is in the range? For example I got this column wit names: name 1 name 2 name 3 name 4 name 5 name 6 name 7