Count occurances in range of cells

E

Ed Gregory

Hello,

I have a range of cells that have multiple values separated by commas. What
I need to do is count the occurrences of a value in a range of cells.

Example:
Cell: A1
Value: win2k,winxp,win2003,win98

Cell: A2
Value: winxp,win2003

Cells A3-100
Value: <same type of format as above>

I need formula that will get number of occurances of "winxp" in each cell in
the range. A cell can have multiple values separated by commas and could,
but shouldn't have duplicate values in cell. I have tried countif with a
wildcard but that only works if search value is first value in cell.

Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif formula perhaps 8
Pasting a range to a single cell 0
Count Blank Cells with Conditions 3
Show value from one cell in another cell if today falls between a date range 5
Excel Countif Function - Calculating Between Two Sets of Values 3
Count a number in a range with cells containing more than one numb 12
Histogram/Frecuency for Multiple Response Questions 1
number to character and vice-versa 10

Top