Hi everyone,
I'm building an Excel sheet for dummies for a fishing club. People that are going to work with this are not used to working with a computer.
Some matches are in a competition form over multiple matches.
In the supplied example I would like the column total points and total weight to have no value until all four matches(points and weight) or at least 1 of the 4 matches are filled in.
Also if possible with a formula or in another way, I would like to leave out the highest number of points and also corresponding weight over 4 matches in the total results.
Highest points are for the worst result in terms of weight.
Thanks for the help.
Bookmarks