IF question

[neil magee]

Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help.
[TABLE="width: 420"]
<tbody>[TR]
[TD="class: xl64, width: 75"]Name[/TD]
[TD="class: xl64, width: 85"]Address 1[/TD]
[TD="class: xl64, width: 65"]Address 2[/TD]
[TD="class: xl64, width: 65"]Address 3[/TD]
[TD="class: xl64, width: 65"]Address 4[/TD]
[TD="class: xl64, width: 65"]Address 5[/TD]
[/TR]
[TR]
[TD="class: xl63"]Neil Magee[/TD]
[TD="class: xl63"]Mountain View[/TD]
[TD="class: xl63"]Kells[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Kells[/TD]
[TD="class: xl63"]Co Meath[/TD]
[/TR]
[TR]
[TD="class: xl63"]Neil Magee[/TD]
[TD="class: xl63"]The View[/TD]
[TD="class: xl63"]Navan[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Co Meath[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"]Mary Murphy[/TD]
[TD="class: xl63"]Springbank Way[/TD]
[TD="class: xl63"]Buttevant[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Co Cork[/TD]
[/TR]
[TR]
[TD="class: xl63"]Brian Murphy[/TD]
[TD="class: xl63"]The Maze[/TD]
[TD="class: xl63"]Nenagh[/TD]
[TD="class: xl63"]Nenagh[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Co Tipperary[/TD]
[/TR]
[TR]
[TD="class: xl63"]David Duval[/TD]
[TD="class: xl63"]6 O'Connell St[/TD]
[TD="class: xl63"]Dublin[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Dublin[/TD]
[TD="class: xl63"]Co Dublin[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

You haven't qualified for us what your requirements are for identifying something as a duplicate.
In addition to posting sample data, it is often helpful to post what your expected results are.