Hi, I've looked in this forum and the help feature in Excel and have only partially succeeded. I'm trying to return an Warranty Expiry Date based on date of...

I am trying to create a formula for the following information: 0 2, 11.33 per month 2 5, 14.66 per month 5 10, 16.66 per month 10 20, 18 per...

Hi all, This rounding issue in VBA drive me crazy! Many posts report that VBA uses the bankers rounding. But I need the standard rounding. So I tried to make...

I have a series of 300 test scores from students and want them automatically numbered from 1-300 based on best to worst. The problem is I want identical...

WinXP Excel 2k3 Ok...this will be long so thank you in advance for reading: I have a spreadsheet with survey results (Analysis!) about users' device...

Not sure if this is possible but I have 3 columns of focus where the rows always change (data dump) Column 1) is product line 2) each product lines $'s 3)...

It's a bit complicated. I have the following function: =SUMPRODUCT((INDIRECT(B1)=1)*(INDIRECT($A$1)=2)*C1) I'd like to calculate a sum of the...

I need to create a loan calculator within Excel that will calculate and generate amortization schedule based upon a 360-day year (30 days per 12 mos). I...

If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30 minutes)

I recently changed from Office 2003 to Office 2007. However now when I print my spreadsheets all my comments appear as little black squares. Normally they...

In cell, suppose I have a number 32 & I want it to be in 4 digits like 0032; for 7-0007; for 200-0200 (It should not change its form from number to...

How do I assign a color to the highest value in a "Total" column so it will stand out and also so it will remain on the worksheet?

In Excel 2007 I have created various pivot tables in tabular form based on data entered in sheet1. I have decided to reflect values (length, width and...

I filled background of 3 columns for my 3 page worksheet (that much info now) but computer keeps adding blank rows (over 3000 now) with the columns...

i pushed some button as i was entering data and the entire worksheet is gone. when i tried to reopen, it said it was already open, so i closed excel and it...

My headers and data are in cells B2-F9. Column headers are the first row (B) and row headers are in the first column (2). Both are text. The data (C3:F9)...

I have a spread sheet that tracks equipment for our company. I split the screen because I record fuel usage and meter readings on a number of pieces of...

I have a list of 20 possible different clients each that will play an advertisement spot with a rate, length and quantity. How would I go about displaying a...

I am using Excel 2007. I have a spreadsheet that has been exported from an in-house software database. It has 57 columns and more than 1,000 rows. A lot of...

I have templates set up to subtract cell A1-B1 and a colume that shows me the amount of change. The default cell value even if A1 and B1 are blank is 0.0. On...