•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to remove duplicate offers.
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com