Finding Duplicate Information

L

ljp1215

Here's what I am trying to do:

In Column A, I have Street Addresses
Column B has a Duplicate or an N/A

I am trying to get a return of data that would show any address that is a
duplicate, but have matching addresses which have an n/a.

So if it was 123 Main St and a Dup, I want to see anything that is 123 that
has a n/a.

I am using MS97

I hope there's someone out there that can help me!

Thanks
 
L

ljp1215

Or maybe a group by might be easier but not sure how write the query. Group
by matching addresses. Would this show everthing that is a duplicate and an
N/A?
 
Top