Thread: How do I index the LAST occurrence of a duplicate number in a colu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJ Murph PJ Murph is offline
external usenet poster
  
Posts: 1
Default How do I index the LAST occurrence of a duplicate number in a colu
I'm trying to find the date (which is in column B) of the LAST occurrence of
a number (in this instance number 1) in column C. This formula only locates
the first occurrence; =INDEX(B5:B410),MATCH(1,C5:C410),0)).


Reply With QuoteReply With Quote