View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
prh prh is offline
external usenet poster
 
Posts: 1
Default excel - removing duplicate entries in spreadsheet

i have a spreadsheet with over 5000 names and adresses. many of these are
duplicated. is there an easier way to delete duplicates other than re-sorting
data to appropriate column and deleting line by line?