I need to be able to change the length of the string of numbers in a column being added using the Sum formula such as: =Sum($A$1:A10), where A10 is a...

Is there a way to setup a formula using Sumproduct to exclude data? Specifically, I'm trying to calculate a weighted average using the following...

I have 2 cells on a work sheet that I concatenate together in cell D27 to give the string '#1'!P15 which refers to cell P15 on worksheet...

I would like to paste a picture in a single cell, but have only been able to paste to the whole worksheet- any suggesstions? What I want to accomplish is...

Using Office 2007 Pro w/XP. While making a lot of changes to a copy of an existing workbook I noticed I couldn't not insert a Text Box. Upon further review...

I first installed excel 2007, then excel 2003 on my machine. when calling excel from VB, it runs excel 2003. how to default to run excel 2007?

Is there a formula that will allow you to search for amount criteria and list the words that meet that criteria? For example, I have the following data in...

After filtering and saving changes, excel will not display any of the rows on the worksheet. I've figured out how to display the rows manually 1 by 1, but...

When importing an excel file the character " ' " appears in front of a zip code; '85004 this hinders the vlookup formula. How can I remove this character en...

In Col. A there are dates, formatted as dates in the format of Sun - Jan 01, 2010 and it goes to the end of 2010. How do I delete all the Saturday and...

I need to sort like this 1 5 90 90a 90b 100 170a 170b

Hoping someone can help me with this. I have a rather large workbook (23 worksheets) that I'm using as a sort of database (because my employer thinks Access is...

I have a calendar that I would like to do the following using conditional formatting: If a cell = d, I would like for it to display the text D/O in white font...

How would I go about making a cell change the text to equal D/O if the cell is equal to "d". I can use conditional formatting to make the text white and the...

Is it possible to create a table of contents to pull from many worksheets based on the heading style used in a cell? The name range/hyperlink functionality...

The autofill box keeps popping up in excel and covering cell info that I need to see. How can I eliminate it?

I'm not sure if there is a formula to calculate what I want or if it will have to be a macro. I'd prefer a formula if possible. I have a workbook that has...

I have a Excel Spreadsheet that was created in Excel 2003, but updated with Excel 2007. Whenever I save it, it runs the Compatibility Checker, and comes back...

In cell b1 i have a named range "month". I want to be able to change the value of month and have the cooresponding values appear in b2-b6. What I'm after...

Ok, I have a spreadsheet that I"m creating to keep track of spending that is coming out of two different accounts. I want to be able to keep a running...