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... |
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... |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com