A five-checkpoint inspection needs a compact progress cue beside each item. Show filled circles for completed checks and open circles for the remainder, while keeping the counts available for sorting and reading.

Repeat two symbols from the numeric counts

Put the completed count in B2 and total count in C2. In D2, use this display formula:

=REPT("●",B2)&REPT("○",C2-B2)

For 3 of 5, it produces ●●●○○. The cells B2 and C2 stay numeric, so use those for calculations and filters.

A sample inspection with three completed checkpoints displays three filled and two open circles.

Illustrated strip. Keep the actual count in adjacent cells.

Check the endpoints before filling down

For 0 of 5 you should see five open circles. For 5 of 5 you should see five filled circles. Validate that the counts are whole numbers and that completed is between zero and total. If your font shows boxes in place of circles, use visible characters such as X and - and keep a text count like “3 of 5” nearby.

The five-checkpoint strip has five open circles at zero and five filled circles at five.

Illustrated boundary check. Verify the display at both ends.

Microsoft’s Excel function reference