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.

Name	Address 1	Address 2	Address 3	Address 4	Address 5
Neil Magee	Mountain View	Kells		Kells	Co Meath
Neil Magee	The View	Navan			Co Meath
1	2	3	3		3
Mary Murphy	Springbank Way	Buttevant			Co Cork
Brian Murphy	The Maze	Nenagh	Nenagh		Co Tipperary
David Duval	6 O'Connell St	Dublin		Dublin	Co Dublin

<tbody>
</tbody>

 

[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.