Duplicate Detection in Excel
Budget: ₹100 – ₹400 INR
I have a spreadsheet that needs a quick but reliable duplicate-check. The goal is straightforward: identify every record that appears more than once and return two things—an updated .xlsx file where the offending rows are clearly flagged and a concise log that lists the row numbers or unique IDs you caught.
Duplicates must be confirmed by comparing multiple columns, with the Name column being the non-negotiable anchor field. If you prefer to add a secondary column (e.g., email or phone) for higher accuracy, let me know; I’m open, as long as Name is always part of the match logic.
Feel free to use whatever you are fastest with—Excel Power Query, conditional formatting, formulas, or a lightweight VBA macro—so long as the final workbook opens error-free in the latest desktop Excel and every flag is obvious to a casual reviewer (a colour fill or an extra status column is fine).
Deliverables:
• Cleaned .xlsx file with duplicates marked
• A brief text or CSV log summarising each flagged entry (row reference and the values that triggered the match)
Accuracy matters more than speed, but this is a small job and I’d like to wrap it up within a day once we start.
Duplicates must be confirmed by comparing multiple columns, with the Name column being the non-negotiable anchor field. If you prefer to add a secondary column (e.g., email or phone) for higher accuracy, let me know; I’m open, as long as Name is always part of the match logic.
Feel free to use whatever you are fastest with—Excel Power Query, conditional formatting, formulas, or a lightweight VBA macro—so long as the final workbook opens error-free in the latest desktop Excel and every flag is obvious to a casual reviewer (a colour fill or an extra status column is fine).
Deliverables:
• Cleaned .xlsx file with duplicates marked
• A brief text or CSV log summarising each flagged entry (row reference and the values that triggered the match)
Accuracy matters more than speed, but this is a small job and I’d like to wrap it up within a day once we start.