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

I

Ivan Medvedev2020-03-04 08:06:16

How to make several page layout options depending on the value of a variable? 2Reply

A

Alexander2019-11-18 18:21:00

Is it possible to build a sparkline on two axes? 1Reply

D

DrSterN2021-05-14 08:12:33

Excel process freezes, how to end after a certain time? 1Reply

C

cherry_velly2019-11-21 07:21:26

How to close a shared file if it doesn't want to close? 4Reply

M

margarittapizza2019-11-22 14:51:25

How to output data from an Excel table to an HTML table on a website? 3Reply

Didn't find what you were looking for?

Ask your question