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 |
How to Remove dup names and if same rate.
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. 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 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 |
How to Remove dup names and if same rate.
I tried =text(a2,"yyyymm") and I'm getting
01/07/07 as the date of what i orginally have. "Dave Peterson" wrote: 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. 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 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 |
How to Remove dup names and if same rate.
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. CYNTHIA wrote: I tried =text(a2,"yyyymm") and I'm getting 01/07/07 as the date of what i orginally have. "Dave Peterson" wrote: 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. 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 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 -- Dave Peterson |
All times are GMT +1. The time now is 01:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com