Hi Kevin,

Thanks for your suggestion. I did that takes too long and I have 2000
lines. I'm wondering if there is a shortcut someone can help me out with.

"Kevin B" wrote:

Click Data/Sort and sort by name/price/month. All of your dupes will be
displayed consecutively and you can delete the rows you no longer want.
--
Kevin Backmann


"CYNTHIA" wrote:

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