Count the people who said yes
A list of replies, and a formula that counts the yeses without counting by eye.
Archive
All posts
62
Find a price from a code
A short price list, a column of codes and a lookup that fills in the price.
Fix the dates that will not sort
Dates that look right but sort wrong, and the quick way to turn them into real dates.
Split a full name into two columns
First names in one column, last names in the next, without retyping.
59
Highlight the rows that are overdue
Colour a row red when its date has passed, and only then.
Average without the zeros
A column with blanks and zeros, and an average that ignores both.
Free
Sunday Cells
A free letter every Sunday: one spreadsheet challenge with three hints, and last week’s worked in full.
“The one email I open the day it lands.”