Finding Unique Values Looking up and down

hi,
i have a least of numbers. i am trying to find all the unique vales and create a Unique ID for each entry. right now my index match only looks up to find duplicates. i want it to also look below.
i am using this now:
=IFERROR(INDEX($AD$1:$AD1,MATCH(1,MMULT(--($AE$1:$AL1=$AE2),TRANSPOSE(COLUMN($AE$1:$AL1)^0)),0)),MAX(AD$1:AD1)+1).
the way my data is sorted now, it will never be an issue, but it is possible for future entries to not fit a match.
any help?
thanks!
see attached sample for clarity

sorry, its my first time posting on here and I'm not sure the best way to communicate this.

my original data set was a bunch of contacts with names, email, and phone numbers collected over time. there are many duplicate contacts but not consistent data for each(names may be misspelled, different emails and phone numbers under each entry etc). I am trying to consolidate all of the data by looking for any overlapping info-if it either shares an email, number, etc. the numbers in my sample represent different emails and phone numbers.

row 2-5 all have overlapping data - ie: they share some numbers. being that at least one cell in each of those rows match, i want any row containing any of those values (2,3,4,or 5) to share the same ID (1001). (in my actual data set this will show me that they are all actually the same person)

Sorting: if in my sample row 4 and row 2 would switch, they would end up with 2 different id's (1001 and 1002). i am looking for a formula that wouldnt have that issue

i could always add another match to column c and so on like this:
=IFERROR(INDEX($A$1:$A1,MATCH(1,MMULT(--($B$1:$H1=$c2),TRANSPOSE(COLUMN($B$1:$H1)^0)),0)),IFERROR(INDEX($A$1:$A1,MATCH(1,MMULT(--($B$1:$H1=$B2),TRANSPOSE(COLUMN($B$1:$H1)^0)),0)),MAX(A$1:A1)+1)
however, i keep adding data which might go past the columns i am currently using, and i dont want to have to manually add for each column if necessary

sorry if it still isnt clear. im not great with my words

Sorry for the long formula, but I noticed no one else has responded, and I spent some time on it, so here it is. Put this in cell A2, then copy down.

Please Login or Register  to view this content.