Compare lists, find differences, and join data safely without breaking keys. Method 1 — Lookup Match (VLOOKUP/XLOOKUP) Goal: pull a column from B into A by matching a key. Sheets: Excel (modern): Method 2 — INDEX‑MATCH (robust classic) Add error handling: Method 3 — QUERY Join (Sheets) Left join A (left) to B (right) by…
Fix messy CSVs fast with copy‑paste recipes for the most common cleanup tasks. Quick Recipes Table Task Sheets Formula / Path Remove duplicate rows (by email) =UNIQUE(A2:D) or Data → Remove duplicates Trim spaces/nonprintables =TRIM(CLEAN(A2)) Proper case names =PROPER(A2) Split full name =SPLIT(A2,” “) or =REGEXEXTRACT(A2,”^(\\S+)\\s+(.*)$”) Standardize phone =REGEXREPLACE(A2,”[^0-9]”,””) Anti‑join (remove overlaps) =FILTER(A2:A, ISNA(MATCH(A2:A, C2:C,0)))…
