View Single Post
  #2   Report Post  
Old November 27th 20, 05:38 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

must I give more specifications ?

In range a 50 : a 1500 there are a a few cells ,
maximum 45 cells with a simple value , from 0 to 450 for example .
They will apear in different adress always . y

so, assume we have in cell a100 value = 89 , in A1 the value must to be 89.
the second value is , f.eg. , in A154 , vith value = 57 ; cell a
A2 must display value = 57 ; between cells filled with values , there are
empty cells , with no kind of data in it.