View Single Post
  #10   Report Post  
Old November 27th 20, 09:46 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

works perfecty both

For the column try in A1:
=SMALL(IF($AE$1:$AX$1<"",COLUMN($AE$1:$AX$1)),CO LUMN(A1))

for this above one , is my last request on today ;
to change rows instead columns, and bring the adress number of
the row with data ,
for below range adress :

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