Have checked to ensure cell is formatted as General, not text, but still Control + Shift + Grave Accent doesn't toggle - I'm still viewing formula rather...

Hi I have a column that contains different terms seperated by Comma. Similar to "Apple, Ball, Cat,Dog, and so on". I have upto 15 unique values that could be...

I need to sum multiple columns based on the value in one column and the excel formula I used below always evaluates to 0 and I can't understand...

Basic question: I am trying to write a macro that looks to see whether A1 = "X" and also if any of A2...10 = "Y", then Statement A, else Statement B. Thank...

I've subtracted two dates and now I want to do a IF statement. Do I have to convert to numeric to do that? It's not bringing up correct values. At this time...

I've setup a spread sheet with everyother line colored to highlight the information. However if I go to change the data in search of something the line...

Hi everyone, Is there a way to enable the sorting feature in Excel when the worksheet is locked? Thanks, GU

I am working on a time sheet that had one other/code column. In the debit column, there was an if function( if(I7="c",h7,"") So if the code =C, it...

I would like to change a field a different color depending on the IF statement being True or False. Anyone know if I can do this in Excel?

Hi all, Pseudo-Follow-Up to my last question: Going based on the below example, how can I write a formula that will give me a count of the total lines that...

Is there a function that causes the current date to appear in a cell whenever the worksheet is opened?

Gang, I have the following iserror...

I have a column in a table with data (A1:A5). Each of these numbers needs to be multiplied by a row in another table (A1:E1). I need the sum of A1*A1 +...

Why is it that after upgrading from Excel 2003 to Excel 2007 users must pick one function over the other in terms of 1) navigating with the mouse wheel...

I have a tab with data, I've made a summary tab where I've used CountIf and SumIf to total the info by state. I want to exclude three lines of data from my...

I have a Pivot table consisting of 25 columns. I would like to customize the sort order of the columns. Here is what I have tried thus far: 1) Dragging...

Hi everyone, I have 6 categories of items, and I want to conditionally format the 7th column to show six different color according to which one of the six...

Ok, Suppose I have 2 worksheets. Sheet 1 has 1000 lines of data spanning xNumber of columns. Sheet 2 has 500 lines of data, also spanning the same number of...

Good morning -- I'm setting up a workbook for several users, in which they will gradually add data over the months and years ahead. I want to set it up to...