How to Remove dup names and if same rate.

[Guest]

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

 

[Dave Peterson]

Maybe...

Insert a new worksheet

Then select your range (A1:C###)
Data|filter|advanced filter
Check Unique records only
(and filter in place)

Then copy the visible cells to the new worksheet.

If that first column is a real date, you may want to add another field:
=text(a2,"yyyymm")
or
=text(a2,"mmm")
to make sure all the days within a month are treated the same.

 

[Guest]

I tried =text(a2,"yyyymm") and I'm getting
01/07/07 as the date of what i orginally have.

 

[Dave Peterson]

Then your original date is just text--it's not really a date to excel.

If your text dates are in a single column
select that column
data|text to columns
fixed width
and choose date (mdy or dmy or ymd or whatever 01/07/07 represents)
and format the way you like (cells|format|number tab)

Then try the formula.