How to delete rows in Excel that match a rule?

Question

excel

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"?

Answer 1

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