Old-school Excel functions like SUMPRODUCT, INDEX/MATCH, and IFERROR remain essential for stable, readable, and maintainable ...
While certainly possible, this is not a practical method of recording such data. Suppose the program needed to record 100 scores? 100 variables would be required!