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