Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default I want to count the cell if contains 111 or 1111

I cant get this one, must have a comma in the wrong place.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format a number (i.e. 1111111111111111) to show XXXX-XXXX-1111-11 rjbind Excel Discussion (Misc queries) 1 July 13th 07 03:45 AM
How to auto count data in an empty cell to be 0. Blank cell=0 Jagneel Excel Discussion (Misc queries) 5 December 13th 06 08:17 PM
I need to make 111-11-1111 into 111111111 Crawdaddy Excel Worksheet Functions 2 September 22nd 05 09:37 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Discussion (Misc queries) 1 January 4th 05 08:01 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Worksheet Functions 1 January 4th 05 08:01 PM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"