Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Flatten numeric readings in a declared scan order

Your goal: Turn a 4 by 3 readings grid into one column while keeping numeric zeroes and excluding text notes and booleans.

Full 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.

Row scan keeps numeric zero and signed readingsKeep actual numeric readings0 cells selected
Scan down columns · F2: FALSE
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
Step 1 of 2

Keep actual numeric readings

Select the source cells in the worksheet, then check your selection.

Rules for this step

Select numeric B2:D5 cells. Include zero and negative readings; text numbers, logical values and blanks do not qualify.

0 cells selected