Hi i have a list of dates coloured either red or green in column A and i want to express the green cells as a percentage of the total list ie 12/02/10 ...

Hi, I have a problem with Countif, and that is it seems to only work where the criteria is 255 characters or less. I have concatenated about 30 columns of...

Somehow I pressed and held the Ctrl key down too long (I guess) and now Excel operates as if I am always holding it down. PgUp & PgDn take me to the next...

I discovered that, after a lot of pain and frustration, a fix for a file corrupted by this error is to simply open it in Open Office calc, and save it down...

Is it possible for one to display graphs based on whether data is present in particular cells? For instance, I wish to display the information of cells A1 to...

I have two columns of data that I export from MS-Access into Excel and then paste into another excel spreadsheet. Column A is my description; Columns B and C...

I am comparing a list of checks from our system to bank checks cleared with a v lookup formula. My problem is when the bank has a check for $100 and our...

Hello, I am trying to create an "IF" formula to indicate an "X" in a cell if the following criteria is met: 10% of entity's Total Assets(C11) and .05% total...

I have a source data sheet which has the following Column E is the division Column F represents the day of the month (ex: 1 thru 31) Column G represents the...

I'm trying to use Excel 2002 to convert feet to kilometers. When I try to use the CONVERT worksheet function, "#NAME?" is returned. It does the same thing no...

Hey everyone, Excel 2003 or 2007 - I have both I have a column of addresses that were entered into one cell at a time using ALT + Enter for the individual...

After I run the macro code (see below) to protect or unprotect all sheets images from other areas of the spreadsheet appear at random when I start to input...

Hi all, I run a dayhome and am trying to make my life easier on myself with my attendance sheet but can't figure out why the formula wont work. I am...

I have a pivot table from a db that shows 10 rows of dates and data. each week i delete the oldest row and add it adds the new one. What i need to do is...

In 2003 you could lock and unlock a form by toggling on the gold lock in the Forms Toolbar. In 2007 it seems to be much more complicated. Is there a simple...

I have a speadsheet with many cells all containing a separate formula. How do I print out the formula of each cell and not the result?

I will like to extract the latest information from a given column in a sheet (sheet1) and place it in another sheet (sheet 2) in B1. Here is my example of...

Hi, I appreciate if somebody can help me with a formula. In one spread sheet I have a list of products and their weights. In that same sheet I want to...

Hi All, I have the following formula to show progress of an item at a particular...

I'm a very very basic macro user, i usually record and then try to manipulate the macro. Question is how do you make a global change to all work sheets that...