2 Columns /Pivot Table Help

[deecee98]

Hi there - my first post & hoping you can help me.

Say I have 2 Pivot tables on a worksheet listing (its for Umpires)

Base Umps

Names # games $ Pay
Fred 2 50
Sally 1 25
George 1 25


Home plate
Names # games $ pay
Fred 1 30
George 2 60
Tom 4 120


**** Question how do I create another table to compile the data of what is owed each person (list only once) - such as:

Name Games $
Fred 3 80
Sally 1 25
George 3 85
Tom 4 120

I cant figure this out ! =)

thanks !

[FDibbins]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-char...re-tables.html