You need a quick spot check of a 40-reading log. Pull every tenth reading into a review list and leave the full log available.
Index the source range by position
Put a header in B1 and sample values 1 through 40 in B2:B41. In D2 enter the formula below and fill down through D5:
=INDEX($B$2:$B$41,ROWS($D$2:D2)*10)The source range stays fixed. The multiplying position grows as you fill down, giving 10, 20, 30 and 40.

Illustrated sampling positions. Keep the source in the order you want to review.
Check the worksheet rows against the positions
The tenth entry is in row 11, and the fortieth is in row 41. If a blank represents a real missing observation, keep its row and inspect that position directly. Removing it changes all the later positions. A repeating problem aligned with the ten-row interval can escape this check, so use a different sampling plan when you need to detect that pattern.

Illustrated row check. Stop before the next position falls outside the source.



