Hi,


My challenge is that I need a formula. This is not a one-time-operation...

Dagfinn

Arvi Laanemets skrev:

Hi

When you don't have a header for column A, enter it into A1.
Select all datarange in A1 (header incl.) and set autofilter on and then to
'Not Empty'
Select filtered data in column A and copy them.
Set autofilter to 'All'
select cell B2. Paste.
It's done!


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Dagfinn" wrote in message
...
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.

What's the formula for doing this??

Regards dagfinn