INDIRECT is a Volatile function and should be avoided where possible... in
this case, the non-Volatile INDEX function can be used instead. See my
second posting in this thread to see a formula solution using the INDEX
function.

--
Rick (MVP - Excel)


"Hong Quach" wrote in message
...
Hi Bill78759,

Let assume column A contain the list of names, the first contain the list
of
dates, and column (date sorted ascendant from left to right).

Let assume Cells A2 to A6 contain the list of names. Cell B1, C1, D1, E1,
and F1 contain the list of date (ascending order)

In cell G1 Enter €œLast Attended€�

The formula to get the last day to be enter in G2 to G6 for each row is as
follow (Change B2:F2 to B3:F3 for 2nd name and so on):

=INDIRECT("R1C"&MATCH("?",B2:F2,-1)+1,FALSE)

You can lookup how indirect() and match() function work. The +1 after
match() is to offset the 1st column to use for name.

I tested the code, and it works!

Hong Quach


"bill78759" wrote:

Have worksheet with dates across top and Names down the left side as a
attendance record. Need to examine each Name row to find that last time
the
individual attended (attendance is indicated by x's in the row). The date
would be from the top row in the column corresponding to the x. I first
posted this in the New User group and have one response, but I need
answer
asap. I know that most responders are volunteers and therefore answers
are
given as time permits.