Duplicate Detection and Removal System

Help me find and handle duplicate data:

**Duplicate Scenario:**
- Data range: [e.g., A2:E5000]
- Full row duplicates: [Yes/No]
- Partial duplicates (specific columns): [Yes/No - which columns]
- Key columns for matching: [list columns that define uniqueness]

**Data Sample:**
[Paste a few rows showing duplicate examples]

**Detection Requirements:**
- Case-sensitive matching: [Yes/No]
- Ignore leading/trailing spaces: [Yes/No]
- Fuzzy matching needed: [Yes/No - for near-duplicates]
- First occurrence handling: [keep / mark / count]

**Handling Preference:**
- [ ] Just identify/highlight duplicates
- [ ] Remove duplicates (keep first)
- [ ] Remove duplicates (keep last)
- [ ] Merge duplicate records
- [ ] Count duplicate occurrences
- [ ] Create unique list

**Output Needs:**
- Highlight duplicates: [Yes/No - what color]
- List duplicates separately: [Yes/No]
- Count unique vs duplicate: [Yes/No]
- Before/after comparison: [Yes/No]

**Tools Available:**
- Remove Duplicates feature: [Yes/No]
- Formulas only: [Yes/No]
- Power Query: [Yes/No]
- VBA: [Yes/No]

Please provide:
1. Formula method (COUNTIF-based)
2. Conditional formatting approach
3. Remove Duplicates feature steps
4. Power Query approach
5. Advanced duplicate scenarios
6. Best practices and warnings