Google Sheets Formula Expert Needed

We are seeking an experienced Google Sheets expert to help us add and optimize formulas for identifying duplicate entries across our spreadsheet. The ideal candidate will have a strong background in spreadsheet functions, data cleaning, and formula automation.

Responsibilities:
Review the existing Google Sheet and understand its structure.
Implement formulas that accurately identify duplicates across multiple columns or the entire sheet.
Ensure formulas are case-insensitive and handle potential whitespace or formatting inconsistencies.
Provide clear instructions or comments within the sheet for ease of future maintenance.
Suggest improvements for spreadsheet efficiency and accuracy, if needed.

Requirements:
Proven experience with Google Sheets, Excel, and spreadsheet formulas.
Strong knowledge of COUNTIF, UNIQUE, ARRAYFORMULA, and other relevant functions.
Attention to detail and accuracy in handling large datasets.
Ability to work independently and deliver on time.

Preferred Skills:
Familiarity with conditional formatting for highlighting duplicates.
Experience with scripts (Apps Script) for advanced automation.

Deliverables:
A Google Sheet with fully functional formulas to identify duplicates.
Optional: Instructions or notes for managing and updating the formulas in the future.

 ... Show more