General

2nd Y Axis
hello How can I add a second Y axis to a chart? Does the chart have to be 3-d? Thanks ... 4 Feb 2010 16:52

IF THEN formulas
I have a series of FROM/TO ratings in a table (see below). I want to build a formula for my spreadsheet that will automatically capture the ADJ Rating whenever the number falls within the From/To Range. Any suggestions? Thanks in advance. Range (from / to) Adj Rating 0.01 0.95 As Is 0.96 0.99 1.00 1.00 1... 4 Feb 2010 19:08

SUMIF using 2 cells that equal each other
I am using SUMIF to add cells in a column but the criteria I want to use is add the cell only if the criteria equals another cell. I do not want to enter the actual variable of the cell as it changes for each row of column C. As an example: =SUMIF('A2:A5001,"C2",D2:D5001) where "C2" equals a variable that can ... 4 Feb 2010 15:44

Conditional Formatting No Longer Working
I created a spreadsheet with conditional formatting in the 97-2003 version... I've recently updated to 2007 Office and not sure if that has anything to do with it, but, when I create new conditional formatting on that same file, I have to 'step off' the spreadsheet for the condition to work. i.e. if $C$29="Yes... 4 Feb 2010 14:37

wrapping text in cell
I searched for this definite answer off and on for about 4 hours when I should have trusted my assumption in the first place. It really sucks to not have the option to adjust the line spacing for wrapped text! I don't know how many times I've had to create 2 or more separate lines to create less space. Just f... 4 Feb 2010 14:37

Can I title columns with out them having a row number?
... 4 Feb 2010 14:37

Excel does not calculate my formulas
This is very strange...Excel does not calculate any formula. I can do a simple =A1+A2, and it just return a zero value. I made sure of the following: - Cell is set to General (tried it with different cell settings too) - Autocalc is on in settings (even a manual F9 calc doesn't work) -- Martin Verville ... 6 Feb 2010 15:14

Text data -- linking Excel sheets
Say if I am surveying 10 people and am asking 5 questions of each and those questions have a text answer (i.e. a sentence or phrase). 1. In Excel 2000, can a master sheet be created listing the text answers to Question 1 from the Excel sheets of the 10 different people? I know this is done with numeric data bu... 4 Feb 2010 15:44

Auto Signature in Excel Send
Excel 2007 and Outlook 2007. When sending a worksheet from Excel, (OB, Send, Mail), it creates the email with the workbook attached with the subject line populated. All correct. Outlook is set to always add a signature to every email, but when the email is initiated from Excel or Word, the signature is not a... 4 Feb 2010 13:29

I am attempting to find the difference between two dates...
I am attempting to find the difference between two dates (in terms of days, months, and years) but I always get an additional month added on. Why? And how can I fix? For instance, if I want to find the difference between 1/1/2010 and 2/1/2010; it returns 2/0/0 ... 4 Feb 2010 13:29