Dealing With Blanks In Excel

In this article you can teach yourself how to deal with blanks within your data.

 

Many times you may have some blanks in your data. Here are tricks to make your life easier: to check if there are blanks and how many of them. Also you will learn how to use COUNTBLANK Excel function.Check if there are blanksFirst tricks is to check if there are blank cells in the column.

To check if there are blanks in A column just use this formula:

=IF(COUNTBLANK(A1:A12)>0,”THERE ARE BLANK CELLS”,”EVERYTHING OK”)

Dealing with blanks

Count of blanks

Second trick is about the number of blanks.

To count the number of blanks in the column just use COUNTBLANK Excel function. Here is a sample formula:

=COUNTBLANK(A1:A12)

Count of blanks

Thanks to them it is easier to handle banks within your spreadsheet.

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
Previous articleExcel IFERROR Function: Error Handling Essentials
Next articleExcel Text Box Linking: Dynamic Data Presentation

RELATED ARTICLESMORE FROM AUTHOR