Thread: Show value of first non contiguous data
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xxer Xxes Xxer Xxes is offline
external usenet poster
  
Posts: 33
Default Show value of first non contiguous data
then try in A1:
=INDEX($A$101:$A$1500,SMALL(IF($A$101:$A$1500<"", ROW($1:$1400)),ROW(A1)))

Brilliant

I remain in debt for you this year .
Reply With QuoteReply With Quote