Just one way to try ..

Put in

B1:
=3DIF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",INDEX(A :A,SMALL(C:C,ROWS($A$1:A1=
))))

C1: =3DIF(A1=3D"","",ROW())

Select B1:C1, fill down as many rows as needed

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----

Dagfinn wrote:
Hi,

I have one challenge:

I want to pick values from one column and place them succesively and
automaticely in a new one - and ignore every empty cell; f.eks.

In Column A there are values/ text in row 3, 5 ,8 and 12 (all other
celles
are empty). These values i want to automatically transferred to
Column B in
row 1, 2, 3 and 4.
=20
What's the formula for doing this??
=20
Regards dagfinn