Which insert size should go in the default kit? The most frequent request is a better starting point for this question than the average length.

Enter all the sizes in the same unit

Put 8, 10, 10, 12, 12, 12 and 14 in A2:A8, measured in centimeters. In C2 enter:

=MODE.SNGL(A2:A8)

The result is 12 cm.

Seven insert requests produce three requests for 12 cm and two for 10 cm.

Illustrated frequency chart. Compare measurements recorded in the same unit.

Confirm how often it wins

Count the reported size with:

=COUNTIF(A2:A8,C2)

Expect 3. The next most common size, 10 cm, appears twice. If several sizes tie for the highest count, report the tie from a frequency table. If every size appears once, MODE.SNGL has no repeated value to report.

The winning size appears three times, so the lead over 10 cm is one request.

Illustrated verification. Check whether the frequency table has a tie.

For measured lengths with small differences, agree on useful size categories before tallying them.

Microsoft’s Excel function reference