| A | B | C | D |
1 | First Name | Last Name | Consecutive Consonants First Name | Consecutive Consonants Last Name |
2 | Ndoluvo | Khaye | TRUE | TRUE |
<tbody>
</tbody>
Using the formula in C2:
=NOT(OR(IFERROR(SEARCH("a",LEFT(A2,2)),FALSE),IFERROR(SEARCH("e",LEFT(A2,2)),FALSE),IFERROR(SEARCH("I",LEFT(A2,2)),FALSE),IFERROR(SEARCH("o",LEFT(A2,2)),FALSE),IFERROR(SEARCH("u",LEFT(A2,2)),FALSE)))
And in D2:
=NOT(OR(IFERROR(SEARCH("a",LEFT(B2,2)),FALSE),IFERROR(SEARCH("e",LEFT(B2,2)),FALSE),IFERROR(SEARCH("I",LEFT(B2,2)),FALSE),IFERROR(SEARCH("o",LEFT(B2,2)),FALSE),IFERROR(SEARCH("u",LEFT(B2,2)),FALSE)))