chiragpandya
New Member
- Joined
- Feb 26, 2018
- Messages
- 5
I want to write a code which will change the corresponding value to minimum of the duplicates set.
Sample Data
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
Sample output
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Number[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4
[/TD]
[/TR]
</tbody>[/TABLE]
Can someone suggest?
Thanks.
Sample Data
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
Sample output
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Number[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ana[/TD]
[TD="class: xl66, width: 64"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Jack[/TD]
[TD="class: xl66, width: 64"]7[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Rachel[/TD]
[TD="class: xl66, width: 64"]4
[/TD]
[/TR]
</tbody>[/TABLE]
Can someone suggest?
Thanks.