View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cynthia Cynthia is offline
external usenet poster
 
Posts: 86
Default Please help. Remove dups automaic of same name,price,month.

I have a spreadsheet called Book1 with 2000 lines.

Where there is a dup in rate , name and month I want to remove the dup
lines from the spreadsheet. Keeping just one line.
If the price is diff but same month, name and rate i want to keep in the
spreadsheet.


Please include necessary info to do this.


Column A Column B Column C
Jan Jane Doe $12
Jan Jane Doe $12
Feb Jane Doe $12
Mar 07 Jane Doe $14



Thanks