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...
|