NOTAIRE
OTARINE
ETAERIO
ANEROID
AILERON
ALERION
ALIENOR
ELATION
TOENAIL
ERASION
Say i have that on a1 downwards , need formula on b1 drag down that will mark ETAERIO as Y
NOTAIRE
OTARINE
ETAERIO
ANEROID
AILERON
ALERION
ALIENOR
ELATION
TOENAIL
ERASION
Say i have that on a1 downwards , need formula on b1 drag down that will mark ETAERIO as Y
B1 formula:
Copy down.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
in B put
=SUMPRODUCT(2-LEN(SUBSTITUTE(LOWER(RIGHT(A1,2)),{"a","e","i","o","u"},"")))
=IF(SUMPRODUCT(2-LEN(SUBSTITUTE(LOWER(RIGHT(A1,2)),{"a","e","i","o","u"},"")))=2, "Y","")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
or try below
=IFERROR(IF(SUM(SEARCH(MID(RIGHT(A1,2),{1,2},1),"aeiou")),"Y"),"N")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you , took samba-ravi as smallest from all answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks