I have a data cluster with some matched results in Excel spreadsheets. I want to sequence them using Macro but am stuck in doing so.
Dataset somewhat looks like as below-
[TABLE="width: 96"]
[tr]
[TD="class: xl65, width: 48"]Set1[/TD]
[TD="class: xl65, width: 48"]Set2[/TD]
A
[/td][td]B
[/td][/tr][tr][td]C
[/td][td]B
[/td][/tr][tr][td]C
[/td][td]D
[/td][/tr][tr][td]E
[/td][td]D
[/td][/tr][tr][td]E
[/td][td]F
[/td][/tr][tr][td][/td][td][/td][/tr][tr][td]G
[/td][td]H
[/td][/tr][tr][td]I
[/td][td]H
[/td][/tr][tr][td]I
[/td][td]J
[/td][/tr][tr][td]K
[/td][td]J
[/td][/tr][tr][td]K
[/td][td]L
[/td][/tr]
[/TABLE]
Note:-- I have simplified the sample Dataset for ease in understanding. The actual dataset is a mixed cluster within columns i.e. they are not in sequence as in the sample.
I am expecting results via using Macro after sequencing them based on matching the related components as below - (Considering A & G as starting points)
[TABLE="width: 288"]
[tr]
[TD="colspan: 3"]Result expected[/TD]
A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][td]E
[/td][td]F
[/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]G
[/td][td]H
[/td][td]I
[/td][td]J
[/td][td]K
[/td][td]L
[/td][/tr]
[/TABLE]
Index and MatchIf functions though help me in getting the results but want to do it via Macro. Also, the dataset size I am taking here is more than 30K (rows).
Any suggestions here? --- where to start
Thaks,
Viks
(Beginner in Macro)