•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to remove duplicate offers.
Our take
Removing duplicate offers can streamline your data analysis and enhance clarity. To achieve this, first identify offers given to customers at a single dealership and eliminate any duplicates for the same vehicle. Next, for customers receiving offers from multiple dealerships, ensure that duplicates are removed within each dealership’s data. While using a macro could simplify this process, you may also explore built-in data management features in your spreadsheet software to efficiently handle duplicates. This approach will empower you to maintain well-organized and actionable data.
Hello,
i am extracting row data from one of our sites and i want to make sense of some data and need to do the following:
- If costumer gets offer only in one dealership, then remove duplicate offers for same vehicle.
- If same costumer gets offer from multiple dealerships, then remove duplicate offers in each dealership.
Is my only solution macro?
Thank you.
| Dealership | Costumer | Offer |
|---|---|---|
| 11410 | Costumer 1 | PEUGEOT 3008 |
| 47436 | Costumer 1 | PEUGEOT 3008 |
| 11410 | Costumer 1 | PEUGEOT 3008 |
| 11410 | Costumer 1 | PEUGEOT 3008 |
| 11410 | Costumer 1 | PEUGEOT 3008 |
| 11510 | Costumer 2 | PEUGEOT BOXER |
| 11510 | Costumer 2 | PEUGEOT BOXER |
| 72 | Costumer 2 | PEUGEOT BOXER |
| 11660 | Costumer 2 | PEUGEOT BOXER |
| 11140 | Costumer 2 | PEUGEOT BOXER |
| 11410 | Costumer 2 | PEUGEOT BOXER |
| 11140 | Costumer 2 | PEUGEOT BOXER |
| 11140 | Costumer 2 | PEUGEOT BOXER |
| 11270 | Costumer 3 | PEUGEOT 2008 |
| 11270 | Costumer 3 | PEUGEOT 208 |
| 11270 | Costumer 3 | PEUGEOT 208 |
| 11270 | Costumer 3 | PEUGEOT 208 |
| 11450 | Costumer 3 | PEUGEOT 208 |
| 11450 | Costumer 3 | PEUGEOT 208 |
| 11450 | Costumer 3 | PEUGEOT 208 |
| 11450 | Costumer 3 | PEUGEOT 208 |
| 11660 | Costumer 4 | PEUGEOT 5008 |
| 11660 | Costumer 4 | PEUGEOT 5008 |
| 11660 | Costumer 4 | PEUGEOT RIFTER |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#natural language processing for spreadsheets#Excel compatibility#row zero#Excel alternatives#duplicate offers#costumer#dealership#vehicle