Compare OFFSET and INDEX dynamic ranges
Your goal: Use one row-count input to resize two real reference methods, then compare their totals, means and selected populations.
Full 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.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 |
Choose the amount total population
Rules for this step
Select the first N physical rows plus the row-count control. A blank occupies a row; numeric zero contributes to COUNT and AVERAGE. OFFSET and the INDEX endpoint describe the same inclusive boundary.