Find Last Occurence
Thanks for the reply. Being a new user of Excel I couldn't get the formula to
work. What would the formula look like if the date array goes from AC7:BK7
the first row is Row 9 (ie: AC9:BK9) and the result would be displayed in
BK8. I need the date of their attendance (corresponding to the last x in
row). There are several x's scattered in the row. I plan to copy the formula
down to get an answer for each student. I tried the formula wizard and it
gave a different formula that returned a date but it was not the last
attendance.
"Teethless mama" wrote:
=LOOKUP(2,1/(2:2="x"),1:1)
"bill78759" wrote:
Worksheet with individuals down and dates across. Attendance is marked with
"x". Need to find last time individual was at work (last x) and return date
in first column.
|