LinkBack URL
About LinkBacks
I have this on A1
BLUETTE
DECTETS
DETECTS
LETTUCE
I have this on A1
BLUETTE
DECTETS
DETECTS
LETTUCE
Last edited by makinmomb; 05-24-2017 at 01:02 PM.
I want on B1 formula that will count vowels
expected results will look as follows
Last edited by makinmomb; 05-24-2017 at 01:03 PM.
Bluette 3
dectets 2
detects 2
lettuce 3
Last edited by makinmomb; 05-24-2017 at 01:03 PM.
Enter formula in B2 and copy down
Formula:
Please Login or Register to view this content.
It may also work with SUM
v A B 1 2 BLUETTE 3 3 DECTETS 2 4 DETECTS 2 5 LETTUCE 3
Formula:Please Login or Register to view this content.
Last edited by AlKey; 05-24-2017 at 02:18 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi AlKey
Noticed your formula is case sensitive so suggest
SUMPRODUCT(LEN($A2)-LEN(SUBSTITUTE($A2,{"A","E","I","O","U","a","e","i","o","u"},"")))
Hope you don't mind
In this case you just have to add UPPER function. It will now work with all capitals or mixed and lower casesOriginally Posted by makinmomb
Formula:Please Login or Register to view this content.
v A B 1 bluette 3 2 dectets 2 3 detects 2 4 lettuce 3
Last edited by AlKey; 05-24-2017 at 03:54 PM.
Thank you ALKEY working always as needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks