I have used the following formula and it works prefectly, however, one of my columns contains % and I want an average not a sum. Is there a way to use...

I would like to assign a macro button to an Excel spreadsheet that when clicked will open up email in Lotus Notes 8.5.1 with the name of the Excel...

I would like to calculate on a daily basis, accumulated vacation time based on the following criteria: Total daily hours (work and leave taken) Hours must...

Hi and TIA. I have a worksheet like so. I'm trying to conditionally format the cells in Column C. If this is possible where do a place a call to the...

Site for some reason, and forbidden http://downfree.zymichost.com/free

It's a logical test rather than a calculation. The example I gave didn't make much sense, but the scenario is that there is a range of products, which can...

Dear All, As you know global warming is endangering the future of life on the planet. It will also affect us; rising sea levels, dwindling water supplies, mass...

I need to regularly reformat numbers in cells into a custom number (000000000). I create a formatted cell and place a number 1 in it (000000001). I thne...

I had encrypted mt files when I had MS office 2003. Now since I've changed it to MS office 2007 I'am unable to decrypt the files. WHat should I do?

hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i...

make a form that looks like a check, then add all information in the check and have the information go to a check register on next sheet

Meant for another question -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message...

Iave saved a 2003 workbook with activeX controls in 2007 as a xlm. How do I get these controls to work in the newly saved workbook?

Hey, Is it possible to create a dynamic pivot table (dependent) that has a relationship to multiple dynamic excel spreadsheets (source's)? Each (source)...

Hello all I need to make sort of pages to be like a dictionary is that possible I put a test file on the next...

Hi, I would like to know how I can make the pivot chart change automaticaly as I change the values in the work sheet? I also would like to know how can i...

I want Excel to lookup a value in a table and return each row it finds that value in. As an example: Lookup Value: Ford Lookup Table: A1: Ford B1: Focus

I'm trying to rank a particular result from one sheet to a range of results from another sheet but it is giving me an error when I do so. Here is the formula...