I'm attempting to average values depending upon a category name (using Excel 2007). I thought this formula would work to average values for Group 1 over...

Is it possible to link from word to excel??? I have a table in Word, would like to fill some of its cell from an Excel Workbook. Possible?? How would I do...

I am trying to setup a formula in one cell to look at a range of cells to see if any are filled with colors. The range of cells contain numeric values and I...

After some automatic downloads from Microsoft I note that my Excel 2003 Pivot Tables again work and can be refreshed with new data in the worksheets (I was not...

I need a drop down that will show a code and a description of that code, but after I select it I only want the code visible.

"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell B1, 5 products category in cell C1, and 5 product list in cell D1." Now, I want...

I am having a problem figuring this out and I'm sure it is quite simple and maybe I am trying to hard but I have a worksheet that an employee enters how many...

Can you tell me how to add comments to an individual cell when the worksheet is protected? The option does not appear on the toolbar nor when right clicking.

Hi I'm trying to run a toolbar function (Refresh All) , from cell M20. I'd rather do this than have it placed on the toolbar. Is it possible to do...

I have a spreadsheet that holds all tasks for a project. Column D holds a catagory and column Q holds the date closed. I need a formula (on a separate sheet)...

I have numerous (approx. 30) 2 letter codes used to identify different type of work events. Some are "soft" events, some are "hard" events. I want to count...

I have a range of cells from B10:B32 that have a few different values in them. I want to be able to count the cells that only contain nothing (blanks) and...

How would I sum a column of numbers, based on the following ranges: 1. 0 - 2500 2. 2501 - 5000 3. 5001 - 10000 4. 10001 - 15000 5. 15001 - 20000 6....

What formula can I use to display the number of spaces indented if the user user formatcellsindent (not the spacebar)?

HELP!!! =IF(AB2, C1 THEN B2) C1 IS A DATE....IF AB2 IS GREATER THAN OR EQUAL TO THAT DATE THEN INSERT AMOUNT IN B2, IF NOT ENTER "0"

I want to insert (or add) a new Worksheet to my existing Workbook, but I want it to appear AFTER my existing (Active) Worksheet. The default places it...

I've always thought CF was one of the more understandable tools used in Excel. Until now. Using Excel 2007. Trying to hilight a cell if it's contents are the...

I have Data in Zip files which I need to get up and running as drop down menus for locating which part is compatible etc. I was sent the data by my main...

I have a worksheet that contains hundreds of columns. Each group of three are related to each other (Cols A-C, D-F, etc...). I have this formula that works...

I want to look in multiple cells and return a predetermined value: I want cell F5 to return a value if there is an X in any of the cells A1 thru A5, if there...