Hallo all

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.

Column 1 Column 2
Yes =A2
Yes =A3
No =A4
Yes =A5
No =A6
Yes =A7
Yes =A8
Yes =A9
"Check" "=A10"
Yes =A11
Yes =A12
Yes =A13
Later =A14
Later =A15

I hope you understand my "problem". Thanks for your help

Best Hans

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

Hallo Claus
Thanks for your reply - This quistion follows up on a previous question, that you also replied.

=MAX(LARGE((B2:B1000<"YES")*(B1:B999="YES")*ROW(1 :999);ROW(1:999))-LARGE(B2:B1000="YES")*(B1:B999<"YES")*ROW(1:999); ROW(1:999)))

But now I see it goes wrong because the list (column) is sorted and some cells are therefore "hidden".
I need the this formular to ignore these cells, which are named by "check" or are empty.

I hope it´s possible - thanks for your help

Best Hans



Den tirsdag den 3. december 2013 15.53.58 UTC+1 skrev Claus Busch:
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