No of times names to be repeated

Enter this array formula in C2 and copy down

Formula:

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

v	A	B	C
1
2	Tom	2	Tom
3	Sam	3	Tom
4	Jerry	4	Sam
5	Ford	1	Sam
6			Sam
7			Jerry
8			Jerry
9			Jerry
10			Jerry
11			Ford
12

Here's another one.

Data Range

	A	B	C
1	Name	Repeat	Name
2	Tom	2	Tom
3	Sam	3	Tom
4	Jerry	4	Sam
5	Ford	1	Sam
6			Sam
7			Jerry
8			Jerry
9			Jerry
10			Jerry
11			Ford
12

This array formula** entered in C2:

=IF(ROWS(C$2:C2)>SUM(B:B),"",INDEX(A$2:A$5,MATCH(TRUE,COUNTIF(C$1:C1,A$2:A$5) < SUMIF(A$2:A$5,A$2:A$5,B$2:B$5),0)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

Note that if a name repeats in column A:

Tom...2
Bob...1
Tom...1

It'll show up in column C like this:

Tom
Tom
Tom
Bob

I don't where you going wrong. So here an adjusted formula

Formula:

Please Login or Register  to view this content.

Originally Posted by goodboy

Also i am using excel 2007.

Please update your profile to indicate that.

Originally Posted by Tony Valko

Note that if a name repeats in column A:

Tom...2
Bob...1
Tom...1

It'll show up in column C like this:

Tom
Tom
Tom
Bob

If there might be repeats in column A:

Tom...2
Bob...1
Tom...1

And you want them to appear separately in column C like this:

Tom
Tom
Bob
Tom

Just let me know.