I am trying to figure out how to get a piece of information into a cell needed for a calculation. This is what I have in one worksheet: 8 ...

Note: Excel '03 SP2 I created a workbook in which each person who accesses it can use the hyperlinks to find the information they require. Until recently,...

I have several worksheets that I need to link to multiple workbooks. Each worksheet in each workbook has a different name. When I copy multiple cells from...

i am looking for a function that returns the number of periods when the period payments are not equal. such as calculating pay back on and investment where...

Hello, I want to enter a number on different cells automatically. I want to do this so I don't need to repeat the process again and again. I want to enter a...

Hi Guys, I have two sheets in an excel 2003 file. Sheet 1 has purchase order# and relevant amounts. There can be more than 1 line record for same PO# on sheet...

Is there a function I can use for the following: Sheet1: A B 1 John OK 2 Mark ...

What function can i use to determine a value from a range? A B c 0 300 0.6 301 600 0.8 601 900 1.0 901 1200 1.2 So if i have a value of...

Copy a sum formula in the below row without affecting the orig value, but how?? or should I use another function?

I want to sort a TOTAL coulmn which includes the value of the function SUM of three other coulmns. The column represents a ranking of players. I want to sort...

This should be simple but i can't see it. How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are different sizes (say) a1:a3 and b1:b6...

Hi, I have created a table with real time and percentage data get refreshed every minute. I need to get the data in column D for that particular...

Hi... I'm working with a Billing Statement in Excel. Going down the colum is the sum of charges and credits from the two columns from the left. The billing...

I have column A that I want to turn the back ground red if the number of months is = 12 in column I. If the number of months is = than 11 I don't want a...

How do I get the headings I choose for page 1 to appear on subsequent pages? I'm sure its a protection thing, but need help!

I have a worksheet that has row headers with Employee numbers, salary, names etc. I want to create a quick lookup that allows me to type in the employee...

Hello In a column A1:A100 I have formulas, where the results are numeric number or an error of type #REF!. I would like to have a sum of all cells, where...

-- Chris K

I would like to add the dates that someone is employed which is easy if you have a Job Start Date and Job End Date. I just go something like C1-B1 and...

How do i make my work book get the most amout of rows and colums to print on each page -- Chris K