RogerVDC
New Member
Hello
I'm from Belgium and willing to learn more about this function, recently I watched a video
from chandoo and was happily surprised by the power. Nice video by the way.
last week I participated in an excel contest " excelchamp' where I encountered a couple of nasty question to solve. In the end I succeeded but I was wondering if you could come up with some short sumproduct () to solve the problems.
btw the contest is closed.
I attached the file and added some comments.
the one I'm most interested in is how to calculate the min score of each atlete ( 8 in total ), store the score of each atlete in a matrix ( an index() ) and use it in other formulas.
of course I could add a column and use the min() but that is not allowed.
thanks is advance
roger
I'm from Belgium and willing to learn more about this function, recently I watched a video
from chandoo and was happily surprised by the power. Nice video by the way.
last week I participated in an excel contest " excelchamp' where I encountered a couple of nasty question to solve. In the end I succeeded but I was wondering if you could come up with some short sumproduct () to solve the problems.
btw the contest is closed.
I attached the file and added some comments.
the one I'm most interested in is how to calculate the min score of each atlete ( 8 in total ), store the score of each atlete in a matrix ( an index() ) and use it in other formulas.
of course I could add a column and use the min() but that is not allowed.
thanks is advance
roger