Practical Excel how-to

Excel How-To Blog

Task-focused guides with exact formulas, careful edge cases, and a live practice exercise in every article.

How to Remove Duplicates in Excel

Delete repeated rows safely, or create a separate unique list without changing the source.

Find matches, missing items, and row-level differences between two lists.

Join name columns cleanly without doubled spaces or lost source data.

Separate delimited text with a built-in command or a formula that updates.

Count text only, nonblank cells, or cells matching a text pattern.

Build reliable monthly totals with real date boundaries instead of month names alone.

Return completed years at today or at a controlled reporting date.

Measure change relative to the original value and handle a zero baseline explicitly.

Convert imported numeric text safely while preserving identifiers and leading zeros.

Review repeated values visually without deleting any source rows.

Return a matching value from a lookup table stored on a different worksheet.

Diagnose the missing match before deciding whether to replace the error.