— CAN YOU SOLVE THIS - EXCEL CHALLENGE 139 —
(Solutions in any language are also welcome for Excel Challenges)
List those sentences which contain any pair of words where first word ends with vowel and next word starts with vowel.
Examples -
- “The orchestra is playing”
“The” finishes with “e” and “orchestra” starts with “o”. - “Kangaroo on a vacation”
“Kangaroo” finishes with “o” and “on” starts with “o”.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dCp7HtAq
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post