Fill a list of names from a formula

Using a formula I want to fill column C with a list of names from column A and the number of times a name appears based on number next to name in column B. See sample below.

A B C
1 Alan 2 Alan
2 Bob 3 Alan
3 Chuck 1 Bob
4 Bob
5 Bob
6 Chuck

or see attachment.

Thanks,
Ken

It is called COUNTIF:
With list is in D2:D7
Name is in A2
Counting in B2:
=COUNTIF($D$2:$D$7,A2)

OK

C2=A2
C3:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

or C3: (non array formula, Enter only):

Please Login or Register  to view this content.