HI. I've tried several different ways now to the experts :) I have two rows of data: Emp Lvl Rating 1 4 2 3 2...

Hi there, I have a big file and in a few sheets I use freeze panes which works fine. But each time I open the file anew after having saved my changes, the...

My question; I've seen somewhere that you can convert a text string into a formula using the INDIRECT Function. What I am constructing is a maintenance...

Sorry about the last post , here is an other copy in sheet R! A D F 1 num time price ...

I have a list of dates over a two year period (in this example it is over 2006-07; although it will vary given different data sets). I would like to create...

in excel 2003 to justify text in a range of cells, you did edit, fill, justify. How the hell do you do it in excel 2007? thanks -- tom ps i hate the new...

Hello All: Here is my situation. I have 3 worksheets (WS1, WS2, WS3). Column A is linked to the same Column A in all 3 worksheets. So, if A1= DOG on WS1,...

I have a formula that pulls info from another page. The formula is: {=INDEX('Patient Count'!$J2:$J5000,MATCH(1,('Patient Count'!$C$2:$C$5000=A2)*('Patient...

hi again - I hope it's OK to ask 2 questions on the same day! This problem is related to the one I posed earlier, but more general. Let's say a sheet has 3...

Hi I am trying to format a spread sheet and need to return the value of colunm C but the problem is Colunm A is blank as it runs in sequence (see below) It...

I am attempting to write a formula in excel 2003. What I am trying to accomplish is to enter a list of values, say 20, 15, 4, 2.5, 1, 3, 6, 8.878, 17, 20.75,...

Hi All, Can I turn a cell’s contents orange If G100today() and G101=0 Or If H100today() and H101=0 Or If I100today() and I101=0 Or

I want to sum a range based on another range of cells. I can detail my problem as follows: Range: 1 Name Points A 1 B 2 C 3 D 4 E 5

Trying to total sum a range of cells in a column and subtract from a total in another cell in the same column, getting a value error ex sum cell a10 to a20...

I use a timesheet in my job & I want to total project times over the course of the year. There are 52 sheets, one for each work week, plus a totals sheet. I...

How do I save precedent lines in Excel 2007? Everytime I try to save them, they disappear.

Cell A1 of my worksheet contains the following formula: ='Retirement Summary'!Retirement_Payment Cell A2 contains a date. Is there any way that the formula...

Hello everybody, I have a master list of books and course. each course has a course number.for each course there are different number of books.the books are...

in sheet R! A D F in sheet H! A in sheet RC! H 1 num time price 1 num ...

I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a...