Excel functions for cleaning up data
Exports from other systems are rarely tidy. These functions help you check what is missing, pull codes apart and make lookups fail gracefully.
Typical jobs
- Check how many entries are really numbers
- Split a prefix off an ID or code
- Spot duplicates and missing values
- Show a clear message when a lookup finds nothing
6 functions to learn
COUNTBeginner
Count how many cells contain numbers
5 lessons · 1 freeLearn it
COUNTIFIntermediate
Count rows that meet a condition
6 lessons · 1 freeLearn it
COUNTIFSIntermediate
Count rows that meet several conditions
5 lessons · 1 freeLearn it
XLOOKUPIntermediate
A modern, flexible replacement for VLOOKUP
6 lessons · 1 freeLearn it
IFERRORIntermediate
Replace errors with something readable
5 lessons · 1 freeLearn it
LEFTBeginner
Pull the first characters out of text
6 lessons · 1 freeLearn it