obtain this result 1

[foxup]

Hi,

I have a Excel worksheet. In column A, I can have X number of rows (it can vary according to the file I receive) and I want to populate columnB. The cells are as follows:

Cell Value
A1 15503
A2 20356
A3 20755
A4 23205

now in columnB, I want to have:

Cell Value Cell Value
A1 15503 B1 $arr[0]="15503"
A2 20356 B2 $arr[1]="20356"
A3 20755 B3 $arr[2]="20755"
A4 23205 B4 $arr[3]="23205"

to do this for all columnB for all rows in columnA ?

Help please,

Thanks,
FOXUP

 

[SkipVought]

hi,
[tt]
B1: ="$arr["&ROW()-1&"]="""&A1&""""
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[foxup]

Awesome!

Star for you Skip.