Hello gurus,
I have data table with 30 columns, each column has sequence number 1,2,...29, 30.
Column number in row 13,
Concat of each column in row 14
Please help to create macro which will compare CONCAT of column 1 with CONCAT of column 2, then 3, ... until 30
next iteration compare CONCAT of column 2 with CONCAT of column 3, CONCAT of column 4,... until 30.
In case of match just wrote below text for example "1 equal 25"
Appriciated for any input, thx a lot!
It will write from cell A15 down:
PHP Code:Sub test()
For i = 1 To 29
For j = i + 1 To 30
If Cells(14, i) = Cells(14, j) Then
k = k + 1
Cells(k + 14, 1).Value = i & " equals " & j
End If
Next
Next
End Sub
Quang PT
perfect, it worksthx a lot!
Hello My friend,
I made small macro, but have big problem, i have repeats column X equal to column Y, but it contain only 0, but i don't needed it. Could you help plz to skip it in the loop?! Table template is attached. Thank you in advance!
Please Login or Register to view this content.
some small changes, focus on the red parts !
snull is a string with x characters "0" with x = lrow-frow
Please Login or Register to view this content.
Last edited by bsalv; 11-26-2021 at 06:12 PM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Magic function, thx a lot! everything works well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks