hi everybody

I have some non contiguous data in an column , column A ,
from range rows 50 to 1500; aprox 40 cells .
I need a function in range A1 to show the value of the first cell with data ,
- or non blank can be say - in A2 a function to show value of the second cell wirh data , and so on , my range A1:A40 to show non contiguous
data from column A50:A1500

I really apreciate your help

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.

Hi,

Am Fri, 27 Nov 2020 08:38:04 -0800 (PST) schrieb Xxer Xxes:

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.

try in A1:
=INDEX($A$50:$A$1500,SMALL(IF($A$50:$A$1500<"",RO W($1:$1451)),ROW(A1)))
and copy down.


Regards
Claus B.
--
Windows10
Office 2016

My God

Sir , you are a really life.saveing

it work perfectly . thank you so much .

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 .

Hi,

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)))


Regards
Claus B.
--
Windows10
Office 2016