I am trying to compare addresses from two different worksheets in a WorkBook. Worksht one D4:D7379 (Address line 1), E4:E7379 (Address line 2) and Worksht...

I don't suppose this is possible, but... K12, K13, etc for about 10 rows need to be totals, totals of several subtotals consisting of (A X B) + (C X D) + (E X...

I keep a list of top 20 costs for my department; I have two columns names of the items and then the cost associated with each in the next column. That is one...

I have a spreadsheet that has two sheets. I would like some of the information on sheet1 to also be in sheet 2 (protected). When I update sheet 1, I would...

How can I get a macro command to print a worksheet please.? Thanks Dave

I am making an energy efficiency calculator for a fleet of vehicles. For each year, make and model, I have specific information as to MPG, CO2, and Air...

Hello, I am learning Excel and have been given a project on generating reports via filtering from the spreadsheet. What is the best logical way to approach...

Ok, this is a little weird, but here's the situation: Column A has the Day of the Week: Monday, Tuesday, etc. Column B has the numeric Date: 6/10/2008,...

Hi I have a source table and a spreadsheet with 2 columns with pick lists. Table1: Type Size1 Size2 (and so on) type1 $10.00 $10.50 type2 ...

In A1, I have a date linked from another file worksheet. I used the If (is blank) formula so no data appears unless there is a date to link from the other...

CAN ANYONE HELP ME!!!! I need to change the colour of the font when a value is greater or less than for example; the value there should be is 5, if the...

I'm using excel 2003, and overlapping pie charts obscure each other even with no fill. Any ideas?

I have a formula in Excel 2003: =SUMPRODUCT((E10:E1740=A1858)*(F10:F1740=B1858)) Which returns the number of rows in my worksheet range where the value in...

When I copy a worksheet into the same workbook I get a warning message that states "a formula or sheet you want to move or copy contains the name...

I have data represented in the following manner Status Date Proj # Team A Team B TeamC O ...

How to write a worksheet function,formula, vlookup so that if a value in a cell is exceeded, the excel window will flash or turn to red? In a financial...

I have the following two functions in the following cells on my worksheet. AJ10 =IF(SUM(AB7:AG7)0,(E47+SUM(AB7:AG7))/(C47+SUM(AB4:AG4)),"") AJ17...

I have a column containing dates (A1:A100) in date format. Colour of all the cells in that column (A1:A100) is yellow and I want to the blank cells as it...

I have a spreadsheet that has invoice numbers in column F which i want to use to link my data into another worksheet. 0001173631 and in another worksheet I...