| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 111555 | 2010-08-02 02:15:00 | Trimming duplicates from Excel spreadsheet? | Chilling_Silence (9) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1123819 | 2010-08-02 02:15:00 | Question #2 for the day. I've got a spreadsheet with customer details for a small business. Lets say they have 3 products. Every time a customer purchases one of their products, their details are recorded in Tab A, Tab B, or Tab C, depending on which product they purchase. Now, most customers have only purchased one product, but some have purchased two products from this company. Basically what I want is to have a 3rd sheet which has *all* the entries in one go, but just without the duplicates, ideally compared by the "email" field so that when this business does a mail-merge to email their clients, some don't end up with two emails. An example of a customer entry would be: Firstname, Lastname, Company, Email, Phone, Fax, Address Is there an easy way to do this? I'm sure I've done it in the past but it's been so long, and I must be Googl'ing for the wrong thing because I'm turning up little results. :crying Thanks Chill. |
Chilling_Silence (9) | ||
| 1123820 | 2010-08-02 02:19:00 | Might be filter - then custom in the drop down box. Or advanced filter. | kahawai chaser (3545) | ||
| 1123821 | 2010-08-02 03:10:00 | Or use find function | SolMiester (139) | ||
| 1123822 | 2010-08-02 04:11:00 | Simplest way I can think of off the top of my head would be to copy sheets 1, 2 & 3 into a 4th 'master' sheet, and then use the Remove Duplicates option in Excel 2007/10. You could also create a pivot table to do this same thing, which by it's nature removes dupes; drop your address/e-mail data into the pivot table as row fields. You could also tell them that data manipulation tools like Excel are bloody poor substitutes for a proper database, which would probably be the best long-term solution!:D |
nofam (9009) | ||
| 1123823 | 2010-08-02 05:12:00 | Thanks nofam, your post prompted me to search again, and I've found this: support.microsoft.com Will give it a shot! |
Chilling_Silence (9) | ||
| 1123824 | 2010-08-02 05:27:00 | Wow that was surprisingly easy ... | Chilling_Silence (9) | ||
| 1123825 | 2010-08-02 06:21:00 | Chill ..... Sounds like you need to use Access as a data base using data imported from Excel. Think it might be an easier way of processing the data into reports. As nofam suggested ... Excel is not a database like Access which makes things a lot easier. |
SP8's (9836) | ||
| 1123826 | 2010-08-02 07:58:00 | Can I assume you are using Excel 2003 or earlier then CS? | Snorkbox (15764) | ||
| 1123827 | 2010-08-03 00:00:00 | Nah 2007. Under the "Data" header, after I copied all the tabs into a single "All tabs", I can highlight the lot and hit "Remove duplicates" and then have it scan just the "email" row for duplicates. Was uber easy, I'm impressed! |
Chilling_Silence (9) | ||
| 1 | |||||