I have a huge database and know there are many dups in it.

Is there an Excel formula (or any other easy way) to find the dup addresses?

What I am trying to do in the following example is look for every address on
the same street name regarding of the additional information in the cell.

123 Main
123 E Main
123 Main Street
123 Main St
123 Main Ave

Is it possible include the ability to pull out the entire row and place it
elsewhere?

Many years ago when I was using a Mac I was able to go to the end of the
database and sent up a location for the data and then do some kind of search
to pull only the matching items and list them below in order to do a print
merge. Never been able to figure out how to do this in the IBM-compatible
software.

Any suggestions?

Thanks.