Find Last Occurence

[bill78759]

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.

 

[Teethless mama]

=LOOKUP(2,1/(2:2="x"),1:1)

 

[bill78759]

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.

 

[bill78759]

Opps - Result would be displayed in BL9

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.

 

[T. Valko]

Assuming the range contains only the TEXT entry X, otherwise the cells are
empty.

Try this:

=IF(COUNTIF(AC9:BK9,"x"),INDEX(AC7:BK7,MATCH("zzzzz",AC9:BK9)),"")

Format as Date

 

[bill78759]

Biff,

Thanks, I was able to get the equation to work. I did have to put a $ sign
to lock the range of the dates. I appreciate your help.

Bill

PS- I did press the yes that it was helpful.

 

[T. Valko]

You're welcome. Thanks for the feedback!