How to copy all rows with specific column in Excel?

I

Ivan Yakushenko2019-08-20 14:58:56

excel

Ivan Yakushenko, 2019-08-20 14:58:56

К примеру, есть такая структура:
-------------------------------------------------------
| Column_1 | Column_2 | Column_3 | Column_4 |
-------------------------------------------------------
| A | B | C | D |
| E | F | G | H |
| I | J | K | D |
-------------------------------------------------------
Как я могу скопировать все строки, где в Comumn_4 есть текст "D" и вставить в другой лист?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

C

coderisimo, 2019-08-20
@kshnkvn

Use the filter :
1
2
after applying the filter to the Comumn_4 column, only rows where Comumn_4 contains the text "D" will be visible.
Copy and paste where it should be. ))