I need to remove duplicates from rows in excel sheet and also find the no of duplicates found in the current row.
<tbody>
</tbody>
Output:
1 2 5 3
6 5 4
6 9 5 4
Can it be achieved using an arrays.
Thanks and regards
~M
1 | 2 | 5 | 1 | 3 |
6 | 5 | 4 | 6 | 5 |
6 | 9 | 5 | 4 | 9 |
<tbody>
</tbody>
Output:
1 2 5 3
6 5 4
6 9 5 4
Can it be achieved using an arrays.
Code:
Dim ArrItem(100,50) as Integer
ArrItems(1) = ArrItems(1,2,5,1,3)
ArrItems(2) = ArrItems(6,5,4,6,5)
ArrItems(3) = ArrItems(6,9,5,4,9)
Thanks and regards
~M
Last edited: