| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search a cell and count
I have cells with various amounts of numbers in them. For example, d6 has
{0, 3, 6, 9} while d9 has {1, 3, 4, 7}. I'd like to count the number of times the numbers 1, 3 and 4 appear in each cell... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search a cell and count
one way.
text to column delimited by comma, countif(a2:a1000,2) -- pleae click yes if it was helpfull regards from Brazil Marcelo "Kellia" escreveu: I have cells with various amounts of numbers in them. For example, d6 has {0, 3, 6, 9} while d9 has {1, 3, 4, 7}. I'd like to count the number of times the numbers 1, 3 and 4 appear in each cell... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| how to search vertically then count horizontally in excel | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
| URGENT: Search for text in column and count by month | Excel Discussion (Misc queries) | |||
Linear Mode
