Hi

I have got a coloumn of IF sentences(=IF(N10=$I$2;K10;" ")) and some
of them return a textstring.
Now I want a new coloumn with just the cells that has a texstring in
them.

The reason for this is that the data is for a drop down list and I do
not want blanks in between the things you can select so I want to
create a new coloumn with no spacings in between the choices.

So if there is a formula that finds and returns the value of the next
non empty cell, could someone help me with that?

Any ideas are welcome, though it cannot be a macro.

Thank you