Six volunteers can be paired for a check-in exercise. You want to know how many different two-person combinations are available before you choose any.

Count the group and the size of each selection

Put 6 in A2 and 2 in B2. Use:

=COMBIN(A2,B2)

The result is 15. To check, try 3 people first. A, B and C give A–B, A–C and B–C.

A, B and C form exactly the unordered pairs A–B, A–C and B–C.

Illustrated small test. Reversing a pair does not create a second pair.

Check what order would change

For six people, there are 6 × 5 ways to pick a first and second person. Dividing by two removes the two directions for each pair. If one role must lead and the other must record, the roles distinguish those directions, so the 15 pairs are not the count of assignments.

Six choices for the first person and five for the second give 30 ordered choices, or 15 unordered pairs.

Illustrated count check. Divide by two because each pair appears twice in an ordered list.

COMBIN counts all mathematical combinations. Apply availability or pairing restrictions separately if the exercise has them.

Microsoft’s Excel function reference