Repita os valores das células X vezes com a fórmula e a coluna auxiliar. Formula to Count the Number of Occurrences of a Single Character in One Cell =LEN( cell_ref)-LEN(SUBSTITUTE( cell_ref,"a","")) Where cell_ref is the cell reference, and "a" is replaced by the character you want to count.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |