Matching cells but exclude blanks
Solved/Closed
Tom9o
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
-
Updated on Nov 12, 2018 at 01:10 AM
Hira - Jul 4, 2017 at 08:18 AM
Hira - Jul 4, 2017 at 08:18 AM
Related:
- Excel index match ignore blank cells
- If two cells match return value from third excel ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
10 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 11, 2013 at 02:36 PM
Mar 11, 2013 at 02:36 PM
Hi Tom9o,
If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, enter the below mentioned formula in C1 and it should work now:
=IF(ISBLANK(A1),"",IF(B1=A1,A1,""))
Do reply with results.
If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, enter the below mentioned formula in C1 and it should work now:
=IF(ISBLANK(A1),"",IF(B1=A1,A1,""))
Do reply with results.
Jul 4, 2017 at 08:18 AM