View Single Post
  #7   Report Post  
Old November 27th 20, 07:29 PM posted to microsoft.public.excel.worksheet.functions
Xxer Xxes Xxer Xxes is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
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 .