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.
I contend that you do not need to enter two lines of data per match, and because of the extra typing and potential errors, you should not do so.
The attached workbook demonstrates this with one line of data per match. Because it uses the VSTACK function, Excel 365 or Excel for the web is required.
SnowMan55 - your attachment will take me some time to get through, but I appreciate the explanation. And you picked great boat names!