Two consecutive consonants in a name and surname

[Zéev2020]

What formula can I use to identify two consecutive consonants in the name and surname columns.eg name Ndoluvo and surname Khaye formula should identify any two consecutive consonants the name and surname starts with

 

[pgc01]

In that case, another option:

=COUNT(SEARCH(MID(A1;{1,2};1);"aeiou"))=0

 

[DanteAmor]

Hi

I tried both formulas for

aabb
bbaa

both have 2 consecutive consonants but I get in both different results for the 2 strings.
Please confirm.

Hi pgc01, I also thought that there were 2 consonants in the whole name, but the OP put 2 examples with the first consonant letters.

in the name and surname columns.eg name Ndoluvo and surname Khaye

My question is if the name and surname, if both have consonants at the beginning, then True.

 

[pgc01]

My question is if the name and surname, if both have consonants at the beginning, then True.

Hi Dante Amor

Good point.

I assumed that we are testing each name separately because in post #1 there are 2 cells with True, but let's see what the OP says.