Extracting commun row numbers set.

[serge]

Hi,
I'm looking for a formula that will find the set of 5 numbers that is in common with the other sets, they will be set that have only 1 number in common or 2 or 3 even 0 but there always will be 1 set that have all 5 numbers in 1 set.

 

[jasonb75]

Maybe conditional formatting applied to $B$1:$F$10 using the rule

=AND($B1=$H$6,$C1=$I$6,$D1=$J$6,$E1=$K$6,$F1=$L$6)

If that is not what you want then a clearer explanation may be required.

 

[serge]

Hi Jasonb75,

That's exactly what I wanted, Thank you so much, I didn't think someone would come up with it, you really help me in my work.

I appreciate you, Thank you.

 

[serge]

I'm sorry I responded to fast after checking the formula , That is not what I needed.
You took reference for the CF of the row H6:L6, thats not what I want, sorry.

What Im looking for is a Formula or CF that will Highlight the 1 set or extract the 1 set that contain the 5 numbers common to all the other sets.
I hope that clear enough ??

 

[JoeMo]

What Im looking for is a Formula or CF that will Highlight the 1 set or extract the 1 set that contain the 5 numbers common to all the other sets.
I hope that clear enough ??

This is not true of the set you highlighted in red in your OP. For example, 14 is not common to all the other sets. Can you provide clarification?

 

[serge]

I apologize for my tread that is not possible to isolate the combination I'm asking for, after looking into it, I found out that all combinations could be the one, I did it in a rush without really look at it.

My apologize to you gentlemen.
Serge.