Find repeats and join them

Hello gurus,

Please help with one macro - it should be able to compare within row 3, if text in column 3 equal to 4, to 5, 6... to 38, then text in column 4 equal to column 5, 6...38, ...and last step if text in column 37 is equal to 38. If the text matches, then return the corresponding value from row 4 (number X= number Y).

Problem is that in case of iterating and comparing text by columns (left to right) I will get list of all repeating entries (7=13, 7=35, 13=35) , but in reality i need to join all repeats in one sentences (look in enclosed example file: "7=13=35")

P.S content of row 4 always fixed, but content of row 3 will vary.

Would be appriciated for any input.

Thx a lot!

Only my guess.

Please Login or Register  to view this content.

Thx a lot, it is working! Just last question: how to list all entries to the cells, and not via message box?

Please Login or Register  to view this content.

and finally last question - if i have counter for output rows, then how this sentence should look like?
If .Count Then [f_i] = Join(.items, vbLf)

Please Login or Register  to view this content.

perfecto, +1 to your carma