murali7197
10-24-2014, 11:17 PM
Hi All,
Please help me in solving the below.
I want to delete one to one duplicate entry in multiple columns.
for example, below is a table with column A and column B with few entries.
col A col B
col A
col B
0
1200
0
1200
0
1400
1200
0
1400
0
0
1400
0
1400
1400
0
I want 1200 in col B to be cancelled with 1200 in col A, 1400 in col B to be cancelled with 1400 in col A, and a fresh list in col C with removing one to one duplicates in col B.
example below.
col A
col B
col C
0
1200
0
0
1200
1200
0
1400
0
1200
0
0
1400
0
0
0
1400
0
0
1400
1400
1400
0
0
Please help me in solving the above.
Please help me in solving the below.
I want to delete one to one duplicate entry in multiple columns.
for example, below is a table with column A and column B with few entries.
col A col B
col A
col B
0
1200
0
1200
0
1400
1200
0
1400
0
0
1400
0
1400
1400
0
I want 1200 in col B to be cancelled with 1200 in col A, 1400 in col B to be cancelled with 1400 in col A, and a fresh list in col C with removing one to one duplicates in col B.
example below.
col A
col B
col C
0
1200
0
0
1200
1200
0
1400
0
1200
0
0
1400
0
0
0
1400
0
0
1400
1400
1400
0
0
Please help me in solving the above.