Count Number of Times Value Appears in Same Cell

[rob51852]

Hi,

I have a sheet where cell D5 is populated with a value each minute by an external source. Is there a formula that will return the word "low" if the value 32 appears three times in that cell?

Thanks

 

[Rick Rothstein]

I have a sheet where cell D5 is populated with a value each minute by an external source. Is there a formula that will return the word "low" if the value 32 appears three times in that cell?

Why don't you show us a few representative samples of the data that could be in a cell so we can get a better sense on how to help you. The things I am looking for is if there is a consistent delimiter separating the numbers you are searching for from the rest of the text and whether the number you are searching for (for example, 32) could appear embedded within other numbers (for example, 432).

 

[FDibbins]

Agree with Rick that we need to see some representative samples, but probably something along the lines of

=IF((LEN(D5)-LEN(SUBSTITUTE(D5,32,"")))/2>=3,"Low","")

 

[Tetra201]

IMO, the OP is talking about a counter -- that is, a VBA solution. Not clear if the "low" should be displayed after three consecutive of three cumulative appearances of 32 in D5.