Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting help
I have a string of numbers (ex. 123111222333123321). Is there a function that
would allow me to count how many 1's, 2's and 3's are in the string? -- Caloyski |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting help
Try a formula like
=LEN(A1)-LEN(SUBSTITUTE(A1,1,"")) This will return the number of 1's in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "caloy" wrote in message ... I have a string of numbers (ex. 123111222333123321). Is there a function that would allow me to count how many 1's, 2's and 3's are in the string? -- Caloyski |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting help
Yes, compare the length of the string with and without a character:
=LEN(A1)-LEN(SUBSTITUTE(A1,"1","")) -- Gary's Student "caloy" wrote: I have a string of numbers (ex. 123111222333123321). Is there a function that would allow me to count how many 1's, 2's and 3's are in the string? -- Caloyski |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting of tickets that have certain criteria | Excel Worksheet Functions | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |