4 consonants in a row in letters

[makinmomb]

Find file attached

I have manually placed Y on cell where i see a word like XYSTUS

Required formula on f1 drag down , the formula to spot words where it finds 4 consecutive consonants at any position in the word

The same formula should also work on SEVEN LETTER WORDS AND EIGHT LETTER WORDS TOO

[Bo_Ry]

Please try

=IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(E1,ROW(Z$1:Z$9),1),"AEIOU"))*(MID(E1,ROW(Z$1:Z$9),1)>"A"),ROW(Z$1:Z$9)),IF(ISNUMBER(SEARCH(MID(E1,ROW(Z$1:Z$9),1),"AEIOU"))*(MID(E1,ROW(Z$1:Z$9),1)>"A"),ROW(Z$1:Z$9))))>=4,"Y","")

Confirm with CTRL+SHIFT+ENTER

[makinmomb]

Wow ,nice thank u so much

[makinmomb]

why is it finding ABBACY too

[makinmomb]

Find attached

[Bo_Ry]

Add =

=IF(MAX(FREQUENCY(IF(ISERROR(SEARCH(MID(E1,ROW(Z$1:Z$9),1),"AEIOU"))*(MID(E1,ROW(Z$1:Z$9),1)>"A"),ROW(Z$1:Z$9)),IF(ISNUMBER(SEARCH(MID(E1,ROW(Z$1:Z$9),1),"AEIOU"))*(MID(E1,ROW(Z$1:Z$9),1)>="A"),ROW(Z$1:Z$9))))>=4,"Y","")

[makinmomb]

Thank you again , now working as required

It would have taken ages without the formula