Looping or iteration after doing conditional formatting on merged cells vba

[Liyun]

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

0down votefavorite ​

I want a macro that can first identify top 3 value and merge these values together, and then find the next highest value from the merged cluster and then add the value to the cluster, and then continue to identify the next highest from the cluster = 1 iteration. Values identified in each iteration will be reflected in another column in order (ideally showing the value and the row name it came from) <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">Eg. D1 D2 D3 D4 T1 5 6 10 8 T2 1 2 3 4 T3 5 6 7 9</code>Identify top 3 value: 10, 9, 8 and then merged together: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> D1, D2, (D3, D4) (T1, T3) 10 12 34 T2 1 2 7 </code>Then from the merged cluster, the next highest for row is D2, then add D2 to the cluster, <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> D1, (D2, D3, D4) (T1, T3) 10 46 T2 1 9 </code>Then from the merged cluster, the next highest in terms of columns is T2, and it will run until all have been identified. I want all the Ts identified in order to be shown in another column. Eg, T1, T3, T2 I thought of using looping, but I couldn't do the macro out. Please help thanks!

<tbody style="margin: 0px; padding: 0px; border: 0px;">
</tbody>

</body>

down votefavorite ​

I want a macro that can first identify top 3 value and merge these values together, and then find the next highest value from the merged cluster and then add the value to the cluster, and then continue to identify the next highest from the cluster = 1 iteration. Values identified in each iteration will be reflected in another column in order (ideally showing the value and the row name it came from) <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">Eg. D1 D2 D3 D4 T1 5 6 10 8 T2 1 2 3 4 T3 5 6 7 9</code>Identify top 3 value: 10, 9, 8 and then merged together: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> D1, D2, (D3, D4) (T1, T3) 10 12 34 T2 1 2 7 </code>Then from the merged cluster, the next highest for row is D2, then add D2 to the cluster, <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> D1, (D2, D3, D4) (T1, T3) 10 46 T2 1 9 </code>Then from the merged cluster, the next highest in terms of columns is T2, and it will run until all have been identified. I want all the Ts identified in order to be shown in another column. Eg, T1, T3, T2 I thought of using looping, but I couldn't do the macro out. Please help thanks!

<tbody style="margin: 0px; padding: 0px; border: 0px;">
</tbody>