I'm using Excel 2007. I have been using a spreadsheet for a basic accounting project and had the following basic formula: =5x+5y When I use the pull down...

I have received an XL spreadsheet from a colleague. When I open it I get the following message: Cannot find 'C:\...'!Register.DClick, which has been assigned...

i am working in a spreadsheet that has usage by week. what i want is for it to look at the cells and give me the highest usage week. Example A1 = 50 B1 =...

In my work, Patients earn "Points" for specific goals and I enter the total in an excel spreadsheet, however, some days are "F"ree and some are "P"ass days and...

How can I use a function to remove spaces from a string. Before Smith , Bob After Smith,Bob Thanks,

I have a number of values (example: H 25%, H 50%, H 75%) in separate cells on column. There are 30 in total. I would like my team to enter one of the values...

How do I write a function that displays "0" when a negative number is the result of a sum?

Hello, I really need some help with the SUMPRODUCT function. I've never used it before but i think i could really help me in this situation. Column A has...

I have a lookup table of nine 4-digit codes in cells A59:A67. I have two cells, M9 and O9, which have the letters A and F inputted in them, respectively. I...

I'm trying to populate a chart using a reference number. On one chart I have names and calculated data that I want to transfer over. I've tried to get a...

Rather than typing in the $ before and after the cell reference, you can hold down a key while clicking on the cell. This shortcut inserts the $ before the...

I'm trying to create a labor schedule which will count the number of employees by job position by the day they work. I've figured out how to count by Job...

Hello all, In Excel 2007, have a data array that contains blank lines. Is it possible to list only the cells with values? Ill give an example:...

Hello, I'm using Excel 2007. I have several values in a certain column, and want to shade each row appropriately. I'll write it out. 'COL D' 1 2 1

Hello, I have a list that includes both blank spaces and text values. How would I go about finding the 'mode' of the text, while excluding the 0's? For...

Is there a way to get the Autofilter Sort function to ignore columns that have a forced blank ("") result in them? I'm trying to sort a column with a formula...

Using Office 2003. In my weatherstation data, , the wind's direction changes are listed as:- NORTH, NE,SE,SE,EAST,ENE,WSW,SOUTH,SE,EAST, NW, WNW, and so on. I...

Good afternoon MS, Please may I suggest you see the copies of messages below. I'm sure "JR1" would be most grateful if you could come up with a remedy for this...

Although I always check the "Notify me etc" box, i don't get any e-mail notification of replies. Can someone please tell me why this is. I'll try it again...

I am trying to produce drop down boxes in Excel That will produce a sub menu from main menu. Glass. Plastic. Metal. Aluminium ...