Thread: first and last occurance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darius Darius is offline
external usenet poster
  
Posts: 41
Default first and last occurance
Perfect thanks

"Bernd P" wrote:

Hello Darius,

That's because one param is missing for MATCH.

Array-enter:
=INDEX(E2:E3286,MATCH(TRUE,E2:E3286<0,0),1)

Regards,
Bernd

Reply With QuoteReply With Quote