View Single Post
  #6   Report Post  
Old November 27th 20, 07:03 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,848
Default Show value of first non contiguous data


Am Fri, 27 Nov 2020 09:47:28 -0800 (PST) schrieb Xxer Xxes:

I cant figure it out to make a little change in this formula to
make the task with 100 cells , A1:A100 for bringing data
from range A101:A1500 .

then try in A1:
=INDEX($A$101:$A$1500,SMALL(IF($A$101:$A$1500<"", ROW($1:$1400)),ROW(A1)))

Claus B.
Office 2016