Conditiontal linking between spreadsheets

  • Thread starter Thread starter Golf Scorer
  • Start date Start date
G

Golf Scorer

I am preparing a scoring workbook for my golf group. I have one spreadsheet
that will contain all historical scores by member. This includes the current
handicap calculation. Not all players play every time, so the number of data
entries in the historical spreadsheet is not the same for all members. I
want to create a second spreadsheet that will have only the current handicap
for each member linked to it. I am trying to figure out how to link the last
non-zero entry in a specific row of the historical spreadsheet to this second
summary spreadsheet. The last non-zero entry in each row of the historical
spreadsheet will change every time a person plays a round.

Any suggestions on this can be done in EXCEL?
 
This will return the last (rightmost) non-zero number in the referenced
range:

=LOOKUP(1E100,1/A1:J1,A1:J1)

Assumes there are no logical TRUE entries in the range.

For example:

81,0,79,77,83,0,0,0,75,0

=LOOKUP(1E100,1/A1:J1,A1:J1)

Returns 75
 
Biff
THANK YOU. This works great. I have completed my scoring workbook and
even created a linked spreadsheet that can be used to check in players every
morning.

Excellent support
 
Back
Top