This was easily solved in our previous Excel database and I agree with sysadmin@nwmaf.org:
Possibly break it down into multiple options:
Show me a list of contacts who have the same last name
Show me a list of contacts who have the same first and last name
Show me a list of contacts who have the same address (peel the first 3 characters of the address field, say) and postal code...
These are the things I manually do in Excel using conditional formatting to find duplicates. If I had the time I would probably tackle it with queries, but we're only dealing with 1500 or so profiles
Swansea
This was easily solved in our previous Excel database and I agree with sysadmin@nwmaf.org:
Possibly break it down into multiple options:
Show me a list of contacts who have the same last name
Show me a list of contacts who have the same first and last name
Show me a list of contacts who have the same address (peel the first 3 characters of the address field, say) and postal code...
These are the things I manually do in Excel using conditional formatting to find duplicates. If I had the time I would probably tackle it with queries, but we're only dealing with 1500 or so profiles