Quote:
Originally Posted by antillies85
So looking at say MIKE's qualification match data, how would you use data to build a profile of which matches a team was involved with and the scores from that particular match?
|
In the qual match CSV, Columns E thru J contain the Team Numbers r1,r2,r3,b1,b2,b3.
Say you want to find all of Team 469's matches in Week2 MIKE2 event.
Insert a new column right after Column J. Now you will have a new blank column K.
Put the heading "Team469" in cell K1.
Put the following formula in cell K2:
=IF(COUNTIF(E2:J2,"469"),1,0)
Copy cell K2 all the way down.
Now each cell in column K contains the value "1" if 469 played in that match, or a "0" if they did not.
Select all the cells in the spreadsheet, and sort by column K descending. All the matches that 469 played in will be displayed at the top of the spreadsheet.
Is that what you were asking?