Please
See file attached manually read and manually marked
Required formula on f3 drag down to mark all words that have last 4 letters last as vowels
Required formula on g3 drag down to mark all words that have last 3 letters last as vowels
Find file attached with expected results
Thank you
Last edited by makinmomb; 03-23-2024 at 03:52 AM. Reason: Thank you
You are doing it AGAIN. An incomplete decription. Which column are we looking at A or E??? Why even include th eother one in your sample???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Just a gentle reminder, now that you are back from your timeout, that any further thread duplication will result in a PERMANENT ban from this forum. Please think very carefully if you open any further threads.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Assuming the column was column A:
=IF(SUM(--(MMULT(--(IFERROR(SEARCH({"A","E","I","O","U"},MID(RIGHT(A3,4),SEQUENCE(4),1)),"")=1),SEQUENCE(5))>0))=4,"Y","N")
change the red 4 to 3 for the 3 last vowels. It may be an array formula in your excel version.
Glenn - no SEQUENCE in Excel 2019.
No?? Oh well then:
=IF(SUM(--(MMULT(--(IFERROR(SEARCH({"A","E","I","O","U"},MID(RIGHT(A3,4),ROW($1:$4),1)),"")=1),ROW($1:$5))>0))=4,"Y","N")
changing the 4s to 3s.
Glenn got me correct , thank you
Why does the formula no copy on additional data
The formula is not in your latest attachment - what's the problem?
Another way:
=IF(ISNUMBER(SUM(SEARCH(MID(A3,LEN(A3)-{3,2,1,0},1),"AEIOU"))),"Y","N")
Phuocam your formula pulled for me these , how about the formula for g3 in which last 3 letters are vowels ?
BANLIEUE
KABLOOIE
EPOPOEIA
FORHOOIE
Did you try this?
=IF(ISNUMBER(SUM(SEARCH(MID(A3,LEN(A3)-{2,1,0},1),"AEIOU"))),"Y","N")
Thank you ALIGW
It pulled me these
INERTIAE
NOTITIAE
METANOIA
EULOGIAE
ABOITEAU
MONILIAE
INFERIAE
MINUTIAE
ACTINIAE
ABOIDEAU
INDUCIAE
INDUVIAE
LACINIAE
FILARIAE
FACETIAE
PARANOEA
PRIEDIEU
DYSPNOEA
PARANOIA
GASTRAEA
TRACHEAE
SILIQUAE
DECIDUAE
ZOOGLEAE
FIMBRIAE
BUDDLEIA
OBSEQUIE
ROUSSEAU
NIRAMIAI
ASSEGAAI
BABESIAE
HYPONOIA
FURCRAEA
HYPOGAEA
ZOOGLOEA
ALLELUIA
FLAMBEAU
COCHLEAE
NYMPHAEA
SAPUCAIA
QUILLAIA
Or try
f3=iferror(if(sum(search(mid(right(a3,4),{1,2,3,4},1),"aeiou")),"y"),"n")
g3=iferror(if(sum(search(mid(right(a3,3),{1,2,3},1),"aeiou")),"y"),"n")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for the rep.
What's the problem???
see fil3e.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks