Hi all, This is a list of three golf foursomes over four days. I would like to know how to get the matrix at the bottom to automatically update as I swap the names around. The matrix shows how many times each of two players plays together. I need a formula that counts the number of times any two names appear in any position in the same foursome. Dan
Thursday DAVE_J DALE TOM MATT Friday DOUG KEN TOM NICK
DAN KEN ED JOE DAN MATT JOE JERRY
DOUG JERRY NICK DAVE_M ED DAVE_M DALE DAVE_J
Saturday ED JOE DAVE_J DOUG Sunday DAN TOM DOUG ED
DAN MATT DAVE_M KEN DAVE_J MATT JERRY KEN
JERRY DALE NICK TOM DALE DAVE_M NICK JOE
DAN KEN MATT DAVE M DAVE J DOUG DALE NICK ED JERRY
DAN 2 2 1 0 0 0 2 1 1 2
KEN 2 2 1 1 1 0 1 1 1 1 1
MATT 2 2 1 2 0 1 0 0 2 1 1
DAVE M 1 1 1 1 1 2 2 1 1 0 1
DAVE J 0 1 2 1 1 2 0 2 1 1 1
DOUG 1 1 0 1 1 0 2 2 1 2 1
DALE 0 0 1 2 2 0 2 1 1 2 1
NICK 0 1 0 2 0 2 2 0 2 2 1
ED 2 1 0 2 0 2 2 0 0 2 2 1
JERRY 1 1 2 1 1 1 1 2 0 1 1
TOM 1 1 1 0 1 2 2 2 1 1 0
JOE 2 1 1 1 1 1 1 1 2 1 0
Bookmarks