Find Last Occurence

  • Thread starter Thread starter bill78759
  • Start date Start date
B

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.
 
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.
 
Opps - Result would be displayed in BL9

bill78759 said:
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.
Click to expand...
 
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
 
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.
 
Back
Top