| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Counting individual #s
That formula worked.Thankyou
"Dave Peterson" wrote: Don't use delimited. Use Fixed Width. Then draw a line between each character. But try that formula first. Mike wrote: One more thing, I have to many columns to individually input delimiters. How do I go about seperating these numbers? "Dave Peterson" wrote: So if you had this in A1:A20: 7887 9078 0650 2222 3620 2389 6653 9583 7377 3391 7961 4067 2913 9477 5401 5365 1697 4048 9004 8613 You'd want to get an answer of 7? If yes: =SUM(LEN(A1:A20)-LEN(SUBSTITUTE(A1:A20,"2",""))) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. Mike wrote: I need to count one number in a number sequence for cells a1:a20. Im trying to count the number "2" in every cell, but every cell has 4 numbers. How do I count only one of those numbers in every cell? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| elseif formula | Excel Discussion (Misc queries) | |||
| Counting individual dates | Excel Discussion (Misc queries) | |||
| Counting Values | Excel Worksheet Functions | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
| Counting... | Excel Worksheet Functions | |||
Hybrid Mode
