Hallo Hans,

Am Tue, 3 Dec 2013 05:22:15 -0800 (PST) schrieb :

The values Column 1 is dynamic. ("based on other data").
I need to copy these values to another column (fx. column 2) WITHOUT the cell value "Check". This column must also be dynamic
It´s not an option to sort this column 2 in a different spreadsheet.

in B2:
=IF(A2<"Check",A2,"")
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2