| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting instances in a cell
Hello,
How can I count the number of times the number 4 repeats itself in a single cell? Example: I have 456444 in A1 and I would like to know how many time the number 4 appears in the cell. Any help would be appreciated. Thanks, Jose R. |
|
#2
|
|||
|
|||
|
One way
=LEN(A1)-LEN(SUBSTITUTE(A1,4,"")) Regards, Peo Sjoblom " wrote: Hello, How can I count the number of times the number 4 repeats itself in a single cell? Example: I have 456444 in A1 and I would like to know how many time the number 4 appears in the cell. Any help would be appreciated. Thanks, Jose R. |
|
#3
|
|||
|
|||
|
Below assumes that A1 containing 456444 is text.
In B1 enter: =(LEN(A1)-LEN(SUBSTITUTE(A1,"4",""))) HTH " wrote in message ... Hello, How can I count the number of times the number 4 repeats itself in a single cell? Example: I have 456444 in A1 and I would like to know how many time the number 4 appears in the cell. Any help would be appreciated. Thanks, Jose R. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
