schardt679
Board Regular
- Joined
- Mar 27, 2021
- Messages
- 58
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
NOTBLANK returns TRUE or FALSE if a cell in a given range is not blank.
VBA Code:
=LAMBDA(Array,
IFERROR(Array&"", 1)<>""
)| REVERSE Test.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | NOTBLANK | ||||||||
| 2 | |||||||||
| 3 | Original Data | Result | |||||||
| 4 | 1 | TRUE | TRUE | ||||||
| 5 | 2 | TRUE | TRUE | ||||||
| 6 | #N/A | TRUE | TRUE | ||||||
| 7 | ABC | TRUE | FALSE | ||||||
| 8 | ABC | FALSE | TRUE | ||||||
| 9 | |||||||||
| 10 | B7 & C8 contain space(s) | ||||||||
| 11 | C6 contains a non-breaking space | ||||||||
| 12 | C14 contains white text | ||||||||
| 13 | =NOTBLANK(B4:C8) | ||||||||
| 14 | |||||||||
NOTBLANK | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C4 | C4 | =CHAR(160) |
| E4:F8 | E4 | =NOTBLANK(B4:C8) |
| B5 | B5 | =CHAR(32) |
| B6 | B6 | =NA() |
| C6 | C6 | =REPT(" ", 5) |
| B13 | B13 | =FORMULATEXT(E4) |
| Dynamic array formulas. | ||
Upvote
0
