•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
#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