I am trying to figure out a good way to do this... So, let's say I want to count the number of vowels in a word... how would I do this?
I don't want to have to do a separate formula for each vowel and I can't seem to get an array formula to work. Does anyone have any ideas?
The list will look like this:
<tbody>
</tbody>
I don't want to have to do a separate formula for each vowel and I can't seem to get an array formula to work. Does anyone have any ideas?
The list will look like this:
A | B | C | D | E | F | G | H | I | |
1 | Word List | # Vowels | Vowels | ||||||
2 | Cupcake | A | |||||||
3 | Argyle | E | |||||||
4 | Liquidator | I | |||||||
5 | Octopus | O | |||||||
6 | Grass | U | |||||||
7 | Y |
<tbody>
</tbody>