6 tutorials tagged “excel”.
Numbers stored as text break SUM, lookups and sorting. Spot them in seconds, then convert with Convert to Number, Paste Special, Text to Columns, VALUE/NUMBERVALUE or Power Query, plus the hard cases.
TRIM leaves spaces behind? Find out exactly which character it is with one formula, then remove non-breaking spaces (CHAR 160), line breaks, tabs and zero-width characters in Excel or Google Sheets.
COUNTIF, COUNTIFS or SUMPRODUCT? A decision table plus tested examples for AND, OR, case-sensitive, row-by-row and month counts, and the edge cases that give wrong totals.
Calculate hours worked in Excel when a shift crosses midnight. Copy the MOD formula, subtract breaks, total over 24 hours, split night hours and overtime. Free timesheet.
Excel dates left-aligned, not sorting, or giving #VALUE!? Detect dates stored as text and convert them with DATEVALUE, Text to Columns, Paste Special or DATE+MID.
VLOOKUP returning the wrong value in Excel or Google Sheets? Fix the missing FALSE argument first, then check duplicates, column numbers, relative ranges and wildcards.