» Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Checking whether or not each of the cells in List1 (column A) is blank, and Counting the Blank Cells.
Solution:
Use either of the following formulas in column B:
=IF(ISBLANK(A2),"",A2)
=IF(A2="","",A2)
Either formula will return the corresponding value from column A only if the cell is not blank.
Use the COUNTBLANK function, as shown in the following formula, to count the number of blank cells in List1:
=COUNTBLANK(A2:A7)
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Windows XP Registry Guide
- Guide to Financial Reporting and Analysis
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Analyzing Markets, Products, and Marketing Plans
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
