I suspect addresses that are duplicated are "similar" rather than exact
matches?

You could start by using EXACT function to see if that identifies exact
matches or possibly COUNTIF to find multiples.

"101guy" wrote:

hi,

i have a huge spreadsheet with addresses in it. i am trying to consolidate
the spreadsheet and getting rid of all the same addresses. what is the
quickest way to do this??

at the mo i have sorted and am going through 1 by 1

does anyone know of a quicker way ???? please