|Not sure how to upload a file?|
I want to search for a code A1,B2,C3 for all matches in column B, I want the result to show all matches, so from the list below the result would be: number 4, (as exact match) then 1,3 (as they both have 2 matches) and finally 2 (with just one match)
This is the code I am using at the moment: to match code in J14 with codes in Column B, but it only shows an exact match, how do I make it list all part matches and rank them?
Range("F25").CurrentRegion.ClearContents: Range("F25") = "Matches"
FindWhat = UCase(Range("J14"))
For Each Cell In Range("B2", Range("B" & Rows.Count).End(xlUp))
If InStr(Cell, FindWhat) <> 0 Then
Cell.Offset(, -1).Resize(, 3).Copy Range("F" & Rows.Count).End(xlUp).Offset(1, 0)