Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove/Ignore Letters when Summing cells in a column. | Excel Worksheet Functions | |||
remove duplicate rows from specific data in a column; excel 2007 | Excel Worksheet Functions | |||
Remove first few digits from all cells in the column | Excel Worksheet Functions | |||
Sum specific cells only not entire column | Excel Discussion (Misc queries) | |||
Remove specific text from a column of cells | Excel Discussion (Misc queries) |