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