neil magee

New Member
Joined
Feb 28, 2019
Messages
1
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.
NameAddress 1Address 2Address 3Address 4Address 5
Neil MageeMountain ViewKellsKellsCo Meath
Neil MageeThe ViewNavanCo Meath
12333
Mary MurphySpringbank WayButtevantCo Cork
Brian MurphyThe MazeNenaghNenaghCo Tipperary
David Duval6 O'Connell StDublinDublinCo Dublin

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,432
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,634
Messages
5,523,996
Members
409,555
Latest member
TIPSAREA

This Week's Hot Topics

Top