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.

The four review rows select positions 10, 20, 30 and 40 from the source range.

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.

Position 10 maps to worksheet row 11 and position 40 maps to row 41.

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

Microsoft’s INDEX function reference