Is this better?- maybe I misunderstood your original request.
I notice that you have a bit of a data quality issue here which will give unwanted results. In the sheet you have 12 Reba Court and 12 Reba Ct which I assume should be the same address.
The easiest way to check for this is to look for entries where the family name occurs more than once (use countif function) and then sort then sort these by address to make it easy to spot the candidates.
Paste
into P2 on the attachment and copy down.
Please post your other problem as a new post. Either myself or someone else will pick it up.
Bookmarks