-
When Text-to-Columns Fails
A functional Van der Merwe story In a column of full names containing first, middle and last names, Excel’s Text-To-Columnsfunction…
-
Shading alternate rows or columns
This is simple enough, but surprisingly few people know how easy it is. It’s a question I get a lot.…
-
Excel: Last Value in a Range
From time to time, we need a formula returning only the last value in a row range, when ranges grow…
-
Excel: a False Phalanx
Musings on the origin of the word Array, and a bit of maths fun with it… Compiler writers are famously…
-
Error Zen
Excel errors (like weeds in a garden) can be useful as indicators. Using IFERROR can mask most ugly horrors preceded…
-
Excel: Search and Replace
Spaces are disallowed in Excel named ranges. If someone, say “Fred Nerx”, wants to name a range after himself, and…
-
Excel: Named Constants
Using Name Manager (on Formulas Tab in Excel 2007/2010) or Name, Define on Insert menu (Excel 21003), add its name…
-
Excel: Reversing a List
If it’s a list that can’t be sorted, like an itinerary, the usual trick is to add an adjacent column…
