P
patenglish
Hi,
I am a member of a local Bass club and we post the results of each 11
tournaments on a spreadsheet. The three lowest tournaments are culled
from the total. I need a formula that will subtract the three lowest
totals from each member. The rows are set up as follows:
Member Name, Tournament 1 points, Tournamnet 2 points, Tournament 3
points, Tournament 4 points, etc until tournament 11, and the last
column is the total points for the tournaments.
The next row has the next member.........
Hope that I have given enough information...If not please advise...
I am a member of a local Bass club and we post the results of each 11
tournaments on a spreadsheet. The three lowest tournaments are culled
from the total. I need a formula that will subtract the three lowest
totals from each member. The rows are set up as follows:
Member Name, Tournament 1 points, Tournamnet 2 points, Tournament 3
points, Tournament 4 points, etc until tournament 11, and the last
column is the total points for the tournaments.
The next row has the next member.........
Hope that I have given enough information...If not please advise...