Compare Multiple Columns to a Master column

[lyla22]

Hi,

I've attached an example to explain what I'm trying to do.

Any help would be great.

[Marc L]

According to your attachment as a VBA beginner starter :

Sub Demo1() 
    Dim F$, C%, V 
        F = Replace("TRANSPOSE(IF(ISNUMBER(MATCH(¤,#,0)),FALSE,¤))", "¤", Range("A2", [A1].End(xlDown)).Address) 
        [K1].CurrentRegion.Offset(1).Clear 
    For C = 4 To [D1].CurrentRegion.Columns.Count + 3 
        V = Filter(Evaluate(Replace(F, "#", Range(Cells(2, C), Cells(C).End(xlDown)).Address)), False, False) 
        If UBound(V) > -1 Then Cells(2, C + 7).Resize(UBound(V) + 1) = Application.Transpose(V) 
    Next 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[xladept]

Try this:

Please Login or Register  to view this content.

[PCI]

Perhaps

Please Login or Register  to view this content.

[lyla22]

Thank you all - all work great!
Much appreciated!

[xladept]

You're welcome and thanks for the rep!

[PCI]

Good news, glad to help you.
Thx for the Rep...!