Macro to find match and color sequence nr thats found

[ricklou]

Looking for a macro to check 100 sequences for an exact

match....if a exact match is found the corresponding

rows sequence number must be highlighted...for the

eaxple I have attached only 10 Sequences. The sequence

must be checked from right to left for a match -Cells V W X.If a

match is found the sequence number in column X must be

highligted. The numbers that must be checked is

highlighted red.For the attached example 2 and 3 have

an exact match..... 4 1 and 2 2

Rep given for someone that can code this in a macro.

Thank you it will be a time saver of note as I need to

check it manually...100 sequences. Sample attached

[Leith Ross]

Hello ricklou,

I think you missed a match in sequence 5. V = 1 and W = 0 matches with D and E.

Why is sequence 2 a match when one of the numbers, V ,is also one of the numbers used in matching?
It seems logical that the matching would start with U.

[ricklou]

Hi Leith...thanks for your response...quite correct i only used 2 examples...sequence 2 will also be a sequence actually as i only want exact matches

Hello ricklou,

I think you missed a match in sequence 5. V = 1 and W = 0 matches with D and E.

Why is sequence 2 a match when one of the numbers, V ,is also one of the numbers used in matching?
It seems logical that the matching would start with U.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.