I can't seem to get a count if formula to work. I have a range of cells see below.
I would like to count the number of times a value is in a cell such as "01" or "24"
The formula returns zero count because I believe it is looking for only the "01" or "24" and if the cell contains other numbers or characters it will pass the cell in the count if formula. am i using the wrong formula or not structuring the count if correctly? I also notice the formula drops the zero on 01 and not sure if that is an issue too.
Thank you for any help...
Jeff
<tbody>
</tbody>
I would like to count the number of times a value is in a cell such as "01" or "24"
The formula returns zero count because I believe it is looking for only the "01" or "24" and if the cell contains other numbers or characters it will pass the cell in the count if formula. am i using the wrong formula or not structuring the count if correctly? I also notice the formula drops the zero on 01 and not sure if that is an issue too.
Thank you for any help...
Jeff
a | b | c | |
1 | 01-03-15-20-22-24-25-37-39-42-43-45-50-58-63-70-74-75-78-80 | ** | ** |
2 | 05-06-15-19-24-25-26-27-30-31-32-42-52-59-60-67-68-75-76-79 | ** | ** |
3 | 04-08-09-14-22-25-34-39-40-43-55-57-58-59-61-64-66-70-71-76 | ** | ** |
<tbody>
</tbody>