Flatten numeric readings in a declared scan order
Enter one formula in G5. Return only the numeric cells from B2:D5 as one column. Ignore blanks, text (including text numbers) and booleans. Retain numeric zero and negative readings. F2=FALSE scans each row left to right, then moves down; F2=TRUE scans each column top to bottom, then moves right. Preserve that order without sorting. If there are no numeric readings, return No numeric readings in one cell.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. Return only the numeric cells from B2:D5 as one column. Ignore blanks, text (including text numbers) and booleans. Retain numeric zero and negative readings. F2=FALSE scans each row left to right, then moves down; F2=TRUE scans each column top to bottom, then moves right. Preserve that order without sorting. If there are no numeric readings, return No numeric readings in one cell.
No account. No upload. Just try it.