Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi All,
Could someone please help me with the following
I have a excel sheet of Emails -
The Columns Run from 1 to 150
In a row sometimes there are multiple occurrence of email
Example bjack4@eq.edu.au
Can be found in Col 3 / Col 60 and Col 120 - I want to retain only one email and remove the duplicate/Multiple occurrences
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]col...[/TD]
[TD]Col[/TD]
[TD]Col120[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[/TR]
</tbody>[/TABLE]
Result required
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]col...[/TD]
[TD]Col[/TD]
[TD]Col120[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Thank You
Could someone please help me with the following
I have a excel sheet of Emails -
The Columns Run from 1 to 150
In a row sometimes there are multiple occurrence of email
Example bjack4@eq.edu.au
Can be found in Col 3 / Col 60 and Col 120 - I want to retain only one email and remove the duplicate/Multiple occurrences
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]col...[/TD]
[TD]Col[/TD]
[TD]Col120[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[/TR]
</tbody>[/TABLE]
Result required
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]col...[/TD]
[TD]Col[/TD]
[TD]Col120[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]djmar2@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jbrow1200@eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Thank You