Thread: I want to count the cell if contains 111 or 1111
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default 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.



Reply With QuoteReply With Quote