ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to count the cell if contains 111 or 1111 (https://www.excelbanter.com/excel-worksheet-functions/174059-i-want-count-cell-if-contains-111-1111-a.html)

M.A.N.

I want to count the cell if contains 111 or 1111
 
I cant get this one, must have a comma in the wrong place.

Tyro[_2_]

I want to count the cell if contains 111 or 1111
 
Hard to say, since you didn't provide us with your formula

Tyro

"M.A.N." wrote in message
...
I cant get this one, must have a comma in the wrong place.




Rick Rothstein \(MVP - VB\)

I want to count the cell if contains 111 or 1111
 
To add to Tyro message...

Also, when you give us your formula, tell us what you mean by "contains". If
a cell has ABC111DE, or 11111111, in it, do you consider the cell to
"contain" 111 or 1111... or for the cell to "contain" 111 or 1111, is that
all the cell can have in it?

Rick


"Tyro" wrote in message
...
Hard to say, since you didn't provide us with your formula

Tyro

"M.A.N." wrote in message
...
I cant get this one, must have a comma in the wrong place.






All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com