In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]
How to quickly select blank cells
In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]
How to automatically fill all blanks with missing data or formula
Question: I have two lists. The first list contains two columns, unique values and names. The second list contains unique […]
Delete blanks and errors in a list
The formula deletes blank cells and cells with errors. It doesn´t matter if the cells contain numbers or text, they […]
How to find errors in a worksheet
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. […]
In this blog post I will provide two solutions on how to remove blank cells and a solution on how […]
Welcome! I am 