LogFAQs > #913264265

LurkerFAQs, Active DB, DB1, DB2, DB3, Database 4 ( 07.23.2018-12.31.2018 ), DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	I need Excel help
Moonroof 11/29/18 5:46:35 PM #1:	I cant find a solution online anywhere. I have eight teams, each containing different variations of the same 12 people. Some games are 6v6, some are 4v4v4, and some are 3v3v3v3. I am trying to calculate how many times each player plays on another players team (e.g., John plays with Carl 4 times, Tracy plays with Kim 2 times, etc.). I color-coded my spreadsheet to indicate which and how many players are on each team, but I cannot figure out a way to translate this into a Pivot Table. Anyone know? <cite>Moonroof posted [p:913264265] in I need Exc... [t:77252519]...</cite> <quote>I cant find a solution online anywhere. I have eight teams, each containing different variations of the same 12 people. Some games are 6v6, some are 4v4v4, and some are 3v3v3v3. I am trying to calculate how many times each player plays on another players team (e.g., John plays with Carl 4 times, Tracy plays with Kim 2 times, etc.). I color-coded my spreadsheet to indicate which and how many players are on each team, but I cannot figure out a way to translate this into a Pivot Table. Anyone know?</quote> ... Copied to Clipboard!
Topic List	Page List: 1