Hi Excel Leaders,
Need help in achieving following:
I got 8 columns
<tbody>
A
B
C
D
E
F
G
H
1
M
W
1
1
4
5
6
=concatenate(a1,b1,c1,d1,e1,f1,g1)
2
M
W
1
1
4
5
6
=concatenate(a1,b1,c1,d1,e1,f1,g1)
</tbody>
Now I want to avoid duplicate values in Column H
Please help me...