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
Microsoft Excel MVP


"Golf Scorer" wrote in message
...
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?


--
Thanks for your help