How to delete rows in Excel that match a rule?

E

Eugene2015-11-20 13:26:05

excel

Eugene, 2015-11-20 13:26:05

Hello!
An Excel table has a set of rows. Some lines end with ",0" and others with ",1". How can I automatically delete those lines that end with ",0"?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

s0ci0pat, 2015-11-20
@vinegred

1. Create a column with only the last character (RIGHT formula)
2. Set the filter to "0" (Data tab)
3. Delete rows
4. PROFIT!

Similar questions

A

Albertic0722021-04-21 16:11:49

Why does the encoding crash when forming a table in excel? 0Reply

C

cyberlain2021-04-21 16:31:27

How to display a list of brands of a specific supplier and sum up the number of items for the found supplier brands? 1Reply

C

cyberlain2021-04-23 12:13:03

How to count the number of articles of a certain length in excel? 1Reply

V

viktorbabykin2015-06-20 03:16:37

Excel files won't open, what should I do? 2Reply

R

Rad1us2015-06-21 16:47:34

How to calculate the sum of a column up to a certain value in Excel? 1Reply

Didn't find what you were looking for?

Ask your question