How do you count (not sum) cells containing special or conditional formatting?

I am using the following formul =IF(A1=A2,B2,"") I want to be able to delete Row 2. How can I get the results of the formula into a cell as a value and not...

First thank you for any and all the help I can get. Can MAX be used with OFFSET and MATCH? I'm trying to find the maximum value based upon MATCHing the value...

Hi everyone, this is my first time to this forum, looks like there are alot of information on this site, but I can't seem to find my solutions, see if anyone...

I'm not even close to a programmer but here is what I need to do. I have a table of multiplication factors that look like this: 0-300 .15 301-500...

When nested subtotals are created for sorted groups, the inside subtotal appears before the external subtotal as expected until the inside group only has one...

Is there a way with out having to physically line uo the columns to compare two or more columns for identifing and flagging any duplicate entrires of ethier...

Having data below in an excel spreadsheet how can I make a unique formula in column D that gives in lines where the text in Column B begins with "Cap" the sum...

I am trying to get a data fit (x,y) to y=ax2+bx+c using worksheet function. If you could help me, I would appreciate very much. PS. I don't want to use excel's...

Need help ... i have an excel document with a "customer number" in column A ... and their "order totals" in column B There are around 12000+ lines in the...

In my worksheet, I have a regular price for general customers and then another for the bigger buyers. How do I not round off in my...

I'm looking for a formula that will replace a look up table. I have a base amount of $250 that increases 5% with each event (compounded) such that the first...

I want to write a report in Crystal looking at an Excel workbook. In Excel - Tools there is an option which opens Crystal . When I do though, I get the message...

I need a formula that looks at a number and gives me a random number that is less than the original number. I'm trying to set up an automatic page...

My columns look something like this: min max value 1 500 1 501 1000 1.2 1001 2000 ...

HELP, After repairing XP Pro with supplied OS cd, none of my Excel files will open. The message is "This file cannot be opened because your virus scanner has...

Hi All, Match Each Numeric occurrence of ONE Criterion and Return Individual Rows of Data (Multiple Columns): the Numeric Criterion may only appear ONCE in a...

Hello all, I am having some trouble with a homework assignment - I am trying to make a graph that has two intersecting lines - the line which I...

I'm a bit confused combining these two functions. What would I use if I wanted to count the cells in a table that are greater than 1.5 but lower than...

Dear Excel experts! Hope I am right here... I would like to create a customer-orientated & task daily checklist. Basically, I want to have a single...