Forum Discussion
Populating a Matrix from a Table
Re: Re 1 — Yes, and the volume of information gets "better", as you will see in my responses to your notes.
Re: Re 2 — You will see the problems in the second attached workbook. result2 is the (intententional) cause of the duplication, not involved in prevention of such. The LENgth functions are just another way of checking for empty strings.
If your Flight + Match combinations are unique, you won't get "contradictory results" by changing boat/team/skipper names. (But rematches late in the regatta would be a problem, which we've not discussed.)
Re: Smokey and the Bandit — No, I never knew that, as I did not watch those movies.
See the attached version.
HansVogelaar,
I like your solution, but I also like peiyeshu's solution that has each cell of the matrix showing the result for both the row and column boat, like this:
Is there a way to use XLOOKUP to do this?
How about this?
HansVogelaar - the conditional formatting is great! But based on the table, the matrix Ws and Ls should look like this:
Essentially, the position of the Ws and Ls above the black diagonal should be reversed from their positions below the black diagonal.
So using the rows to read Boat1's results (moving left to right), I read the result below each cell's diagonal line - loss to Boat2, loss to Boat3, win over Boat4. And using the columns to read Boat1's results (moving top to bottom), I read the result above each cell's diagonal line.
