how to reference data from a list

[johnpp2]

Hi
So I have a list of data, like this

tom Tim
John Paul
Tom John

I want to find a way to tell me how many times a name has appeared, so in this example my 2 new columns telling me this would be

tom Tim 1 1
John Paul 1 1
Tom John 2 2
Sally Tom 1 3

So in the third row both Tom and John are shown as the number 2, because they have already appeared in one of the two columns once each. In the forth row sally is a 1 as it is the first time her name has appeared, but tom is a 3 as it is the third time his name has appeared.

Any help is greatly appreciated.

[alansidman]

v	A	B	C	D
1	tom	Tim	=COUNTIF($A$1:$B1,$A1)	=COUNTIF($A$1:$B1,$B1)
2	John	Paul	=COUNTIF($A$1:$B2,$A2)	=COUNTIF($A$1:$B2,$B2)
3	Tom	John	=COUNTIF($A$1:$B3,$A3)	=COUNTIF($A$1:$B3,$B3)
4	Sally	Tom	=COUNTIF($A$1:$B4,$A4)	=COUNTIF($A$1:$B4,$B4)

[johnpp2]

Thank you for help