Hi, this is probably really simple but I just can’t get it to work!
I have an excel sheet for a sporting events which I want to determine the placings for.
There are Three criteria for placings in this order:
least number of Non Completes
Least number of Penalties
Quickest time
so someone might have the slowest time but if they have the least non completes, least penalties then they win.
Any help with a formula is appreciated.
I have an excel sheet for a sporting events which I want to determine the placings for.
There are Three criteria for placings in this order:
least number of Non Completes
Least number of Penalties
Quickest time
so someone might have the slowest time but if they have the least non completes, least penalties then they win.
Any help with a formula is appreciated.