Hi all, How do i do a date calculation that will return partial years? I have been using Dated Ifs and I only get whole years...

I would like to know if there is any way other than the normal cut and paste to merge data from several worksheets into one??? If anyone knows how please...

I have two columns of data. Col A Col B 1W 10 2P 20 3G 30 15P 90 16G 5 18W 15

Just do an editreplace and replace Sheet1 with Sheet2 Another way would be to use a reference to the sheet in the...

I would like to have the Excel document form automatically add a number in sequence so we can track each document. For example: We have paper forms with...

Hello, I have a destination file where I'm using a SUMIF function referencing the source data saved in another workbook. When both files (the destination file...

I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work...

I have the data below: Number of Jobs BeginDate EndDate TotalDays 107 1/2/04 2/3/04 31 50 1/23/04 2/20/04 28 etc... How can...

I'm putting together a spread sheet to show the month % change. My columns run from Jan - Dec with a YTD column. And I need to calculate the difference, can...

"Nali" wrote in message ... I need a formula that keeps a running total. I...

I have about 3000 rows in worksheet1 and 3500 rows in worksheet2. Is there anyway to copy all the duplicate rows from worksheet1 & worksheet2 to...

Hi All, In column A I enter invoice numbers. Occasionally the same invoice number is entered by a mistake. How to avoid that? Perhaps in column B a warning...

I am trying to print an excel spreadsheet showing lines and I can't seem to figure out how. Can someone help me?

Does anyone have charts for amortization and comparing 5- 1 ARM, 7-1ARM, 30-yr fixed loans etc? Thanks Kaushik

Hey there! I am using Excel 2002 and I have a speadsheet that has prices in it. If I have the filter set to (the filter criteria is much more complex...

(Excel 2000) I need to create a formula that does the following: 25¢ per hour added on, if you are under $13.00 (but you could only move to a maximum of...

I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I...

I have a workbook for a company budget with an intentional circular reference (calculate a loan balance, then calculate the interest charge on that which...

Having spoken to my manager - here is a list of things that would be useful for me: IF functions (also IFISERROR) LOOKUP tables Connecting to...

Good morning Rose - What you describe so far can be done with a macro in Excel. You could start by recording a macro that does what you want it to do - from...