» Creating Formulas that Only Return Results from Non-Blank Cells

CATEGORY - Excel Formula and Function VERSION - All Microsoft Excel Versions

Problem:

We want to create a formula that only returns a result from the non-blank cells in List1.

Solution:

Use the ISBLANK function as shown in the following formula:
=IF(ISBLANK(A2)=FALSE,A2,"")
To return text values only, use the ISTEXT function as shown in the following formula:
=IF(ISTEXT(A2),A2,"")
To return numeric values only, use the ISNUMBER function as shown in the following formula:
=IF(ISNUMBER(A2),A2,"")
Screenshot // Creating Formulas that Only Return Results from Non-Blank Cells