Fill a column with the MODE from another column per unique value of a third column

[Nato595]

I am looking for a formula that will fill column C with the Mode value from column B, for each unique value in column A.

In my below example, pretend that only columns A and B are filled, I want this formula to fill C with what you see.

john 2 2
john 47 2
john 2 2
john 2 2
john 1 2
john 1 2
sally 15 15
sally 15 15
sally 15 15
sally 7 15
pimpy 12 16
pimpy 16 16
pimpy 16 16
pimpy 16 16
pimpy 12 16
pimpy 4 16


Thanks in advance!!

 

[Nato595]

Excel Workbook
	A	B	C
1	john	2	2
2	john	2	2
3	john	2	2
4	john	2	2
5	john	1	2
6	john	1	2
7	sally	15	15
8	sally	15	15
9	sally	15	15
10	sally	7	15
11	pimpy	12	16
12	pimpy	16	16
13	pimpy	16	16
14	pimpy	16	16
15	pimpy	12	16
16	pimpy	4	16
Sheet1

 

[barry houdini]

You can use this "array formula" in C1

=MODE(IF(A$1:A$16=A1,B$1:B$16))

confirm with CTRL+SHIFT+ENTER and copy down.

Note: that MODE gives #N/A if there are no repeated values (for any name)

 

[Nato595]

Brilliant!
You saved me hours of somebody else's time... thank you much!!