View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rachael Rachael is offline
external usenet poster
 
Posts: 25
Default Filtering duplicate information

Hi,
I have a large speadsheet where some of the columns are identical.
i want to remove the duplicate rows entirely where the identical columns
occur.
i've tried using the advance filter function but because the rows are
slightly different it doesnt work
can you help please

thanks