Compare OFFSET and INDEX dynamic ranges
Keep all eight records in place. G2 is a stored integer from 1 through 8 and selects exactly the first N physical rows starting at row 2, including any blanks and numeric zeroes. Build G5:G9 with actual OFFSET references and H5:H9 with actual INDEX endpoints. Compare each corresponding result in I5:I9. Amount and units totals ignore true blanks; the amount mean includes numeric zero and ignores true blanks. If no selected amount is numeric, return No numbers for both mean methods. Physical rows is N; Numeric amounts counts the selected numeric amount cells. Measures are stored finite whole-cent numbers within ±1,000,000 or genuine blank cells. Text and Booleans are not source measures for this exercise. These independent report formulas must not be filled over one another.
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
Keep all eight records in place. G2 is a stored integer from 1 through 8 and selects exactly the first N physical rows starting at row 2, including any blanks and numeric zeroes. Build G5:G9 with actual OFFSET references and H5:H9 with actual INDEX endpoints. Compare each corresponding result in I5:I9. Amount and units totals ignore true blanks; the amount mean includes numeric zero and ignores true blanks. If no selected amount is numeric, return No numbers for both mean methods. Physical rows is N; Numeric amounts counts the selected numeric amount cells. Measures are stored finite whole-cent numbers within ±1,000,000 or genuine blank cells. Text and Booleans are not source measures for this exercise. These independent report formulas must not be filled over one another.
No account. No upload. Just try it.