Thread: Find Last Occurence
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Find Last Occurence
=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.
Reply With QuoteReply With Quote