Excel for Data Analysts

Lookups, deduplication, text splitting, and conditional logic to clean and analyze data without leaving the sheet.

Common needs

  • Look up values from any column (including left)
  • Deduplicate lists and keep first or latest
  • Split names, emails, or delimited text into columns

Recommended formulas

Recommended tools

Try a formula