LogFAQs > #913264674

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
TopicI need Excel help
Oxbridge
11/29/18 5:53:35 PM
#3:


If each team is listed in a row or column then just do =COUNTIFS(range, name1, range, name2)

You can extend this to see how many times 3 or more players are on the same team, just add the range and the next player.
---
Congratulations to BKSheikah, the Guru champion for the 2017 Best Year in Gaming contest.
... Copied to Clipboard!
Topic List
Page List: 1