Working out an average based on a previous cell contents

I Am trying to work out averages based on whats in another cell

example:
A B
1 Name 1 | 3.33
2 Name 2 | 3.26
3 Name 3 | 3.32
4 Name 2 | 6.26
5 Name 1 | 3.32


Name 1 | So here would be average of B1 and B5
Name 2 | So here would be average of B2 and B4
Name 3 | So here would be average of B3 (yes I know can't be an average of just 1 number this is just example)


Problem is Both A and B can change so next time could be

A B
1 Name 2 | 3.68
2 Name 3 | 3.99
3 Name 1 | 3.48
4 Name 2 | 5.10
5 Name 3 | 1.01


Name 1 | So here would be average of B3
Name 2 | So here would be average of B1 and B4
Name 3 | So here would be average of B3 and B5

Any help would be greatly appreciated Thanks

Ok I tried that and as all it shows in the result area is #NAME
I have included a test file so you can view if that would help

Awesome Thanks Worked Perfectly