Identify Duplicates based on Name + DOB across columns

[acidburn786]

Hope some1 can save me 3 months of work.

I have a list 250 000 rows, of which some duplicates exists. I Need to identify the rows with duplicate names

Column A - Contain Customer name (In a row, it may be Firstname Middle name Surname OR Surname Firstname Middle name) in some instances there is 6 names ,or just initial and surname

Thus I can't use a normal Conditional format to find duplicated, cause the names appear in different sequence within 1 cell.

Column B - Date of Birth

C,D,E,F - Lots of other info

I already split the name into 6 columns

The way I want to check if it is a possible duplicate, is to look at where any of the names match where the Date of birth is the same.
Example:

Row 1 - Johannes | petrus| van | wyk| 1981/01/31 -Possible duplication - pls check
Row 2 - van| wyk | johan| petrus| 1981/01/31 -Possible duplication - pls check
Row 3 - PJ|van|wyk 1981/01/31 -Possible duplication - pls check


Thank you in advance