I've got a single column of coded data in Excel like this:

a
b
ab
bc
ad
b
ac

I know I can find the instances of all cells containing "a" with =COUNTIF(A1:A7,"*a*"). That would give me 4. I can also count "b" =COUNTIF(A1:A7,"*b*") which results in 4.

However, what I need is to count cells that contain "a" OR "b" but doesn't double-count cells containing both.

In Excel 2013 or 2010, if you put this value in column B1:

2014022701000400

And then this formula in column C1:

=COUNTIF(B1,"2014022701000409")

The formula will evaluate to 1. But the numbers are different: the one in the formula ends with a 9, the one in the cell ends with a zero.

Why does countif match a value it shouldn't? Is there a workaround available?

I know there's a formula for this in Excel but I can't get it right.
I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A and column B.
I want to filter and display the result in column C of those names that ONLY appear in column A.

I have a excel workbook where there is a hidden sheet that basically pulls data from other sheets in the same workbook just using the = formula. the problem I am having is if I add a column or cells to sheet the formula is pulling data from it adjust the formula on the hidden sheet. I do not want this to happen.

I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:

Applepie
Applesauce
Crabapple
Banana
Mango

What I need is the count of all visible cells containing the word "Apple".

My english isn't that good, I hope you understand what I wan't to accomplish

I have a column (A) with different zip codes ( total of 3583 rows). I need a formula/function to go through each cell and the come up with sum of how many instances (column B) there are of the same zip code (column C).There are probably more than hundred different zip codes so I can't do it manually.

This is the formula I'd like to print to each cell going down the column:

=VLOOKUP(CONCATENATE(E2,C2), WORKABILITY_INDEX!$A$1:$B$82, 2, FALSE)

I am using a statement like the one below:

Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 2 Step -1
If (Cells(i, "A").Value) <> "" Then
Cells(i, "L").Formula = "=VLookup(Concatenate(RC[-8],RC[-10]), ""WORK

I have a large dataset in an Excel sheet where:

column A: quote number
column B: opportunity number
column C: sales order number.

One quote number will have multiple opportunity numbers. A sales order number will be generated if an opportunity is closed. What I need is a formula that can flag a quote as "closed" status when all opportunities related to that quote have a sales order number.

I am trying to create a formula to count the unique number of entries in column A, when Column C says NO and column D says YES, but I cannot devise a new formula to do this based on 2 other criteria. Would really appreciate some help if anyone can figure this out?

E.G.