Excel 2003 I have a formula that counts all the "yes"s in a range of cells which it does correctly. in the next cell I have the exact same formula counting...

Does anyone know what the underlying formula/macro is that this function uses to determine bin size. I have a normal distribution for which I am using a...

This is a little confusing, so I'll try to explain. We need to average sets of data from a larger set. We want to take the total length of the data and...

I am unable to unhide my personal workbook with my macrso. The unhide feature under the window menu option is greyed out. I've used Format, Sheet and the...

I would like to have an automatic date (in a cell) that updates only when the worksheet is revised. Is there such a thing?

-- Lynette

In excell 2007 I trying to match up two columns of data. If certain cells in the rows of either column dont equal each other I want to shift one side of the...

I need to write an IF statement that will tell me the following: If A1 is = 1 but 2, return 92.5% If A1 is = 2 but 3, return 95% If A1 is =3, but 4,...

Hello: I exported an xml file from an application called Wall Street Office (microsoft sql-based). I have just installed Microsoft Excel 2007 where I can...

I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it as DUP else goto next line and repeat the action. Compare C4 to C3, etc. --...

Hi, I am working with a workbook that has 3 sheets. I need to add 2 columns together and have the result appear on sheet 1. I've tried =sum('08 compaired...

Can't get my head around this one (perhaps it's just Friday!) Cell B15 has a simple formula (Adding two cells) Cell B16 shaves off a couple of numbers number...

How do I check whether the same string value appears within a range of cells e.g. A 1 JD ...

Example: (see explantion below) Column A Answer 1 LMS LADprox 3 (2 for LMS,0 for LAD prox and LADother,1 for RCA) ...

if there's a # in the "Qty. Received" cell then I want it to add to the "Current inventory" cell but if there's a # in the "Qty. Shipped" cell then I want it...

I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create...

Please can you help me with a simple question! I want to conditionally format cells whose absolute value is greater than 1, ie, negative numbers -1, and...

Has anyone else notice a drastic performance issue with Excel 2007's conditional formatting? I have a workbook and code that I wrote for XL2003 which has...

How can I Track changes on worksheet using colour to highlight differences on COLUMNS that are change from the last modification when opening the file. I...

I want to populate cells on worksheet 2 from worksheet 1 with values that a user selects from worksheet one. The user can select multiple values but I only...