A display strip takes six tabs: three A, two B and one C. You care about the visible order of the letters. Swapping one A tab for another does not create a new display.

Put 3, 2 and 1 in B2:D2, with headings A, B and C. Enter =MULTINOMIAL(B2,C2,D2). Expect 60. Starting from 6 factorial counts all six positions as distinct. Dividing by 3 factorial and 2 factorial removes the repeated arrangements created by the identical tabs.

The label counts 3, 2 and 1 appear beside the six tabs in the example sequence.

Example input. Count each distinguishable label type once.

List a small control by hand

With two A tabs and one B tab, the only visible sequences are AAB, ABA and BAA. The same function should return 3 for those counts. Use this control if you want to check that your workbook is counting labels instead of identifying individual tabs.

A small check lists the three arrangements AAB, ABA and BAA.

Example control. Swapping two identical A tabs leaves the sequence unchanged.

If the first position must contain C, handle that rule separately and count the remaining positions using only the unfixed tabs.

Microsoft’s MULTINOMIAL function reference.