hi all
I'm trying to build a macro which has some function to eliminate the same value based on column. and here is my sample data
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]four[/TD]
[/TR]
</tbody>[/TABLE]
the result i want to display is like this
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]four[/TD]
[/TR]
</tbody>[/TABLE]
thanks in advance
I'm trying to build a macro which has some function to eliminate the same value based on column. and here is my sample data
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]four[/TD]
[/TR]
</tbody>[/TABLE]
the result i want to display is like this
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]two[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]three[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]four[/TD]
[/TR]
</tbody>[/TABLE]
thanks in advance