View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cynthia Cynthia is offline
external usenet poster
 
Posts: 86
Default How to Remove dup names and if same rate.

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 ALL necessary info and steps.


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



Thanks