Hello, I have a huge Excel file I copied in LibreOffice Calc. I need to get rid of rows containing let’s say X so the alphabet is random and used over 4000 times but I only need to get rid of rows with x in it. There are hundreds of rows with x in it
What exactly means »let’s say X«
I would first ensure that there is a first row with row labels, so if it does not exist, just insert a row at the top and put some labels.
Second, I would add a column at the right with the numbers 1, 2, 3, etc. up to the last row.
Third, I would select the whole range (from A1 to the last row and rightmost cell) and click on the menu Data > Autofilter.
Then, I would filter all the rows having “X”.
Once the rows with “X” are shown, I would delete the content of these cells.
Then I would deselect the filter “X”, so the table shows some rows with values and some empty rows.
Finally, I would select again the whole set of data and sort it according to the content of the last column, so the empty rows will be moved at the bottom of the set of data.
And last of the last, I would delete the content of the added column and the header row (if you added it at the beginning).
2 Likes
Thank you Steph1 !
In case your X occurs in a specific column (you didn’t say):
- Add new empty sheet, here Sheet2
- Select original data range
- Menu Data → More Filters → Standard Filter…
-
- Choose Field name that would contain X, Condition Does not contain, Value
X
- Choose Field name that would contain X, Condition Does not contain, Value
-
- Open ⯈ Options
-
-
- Check Copy results to and enter
Sheet2.A1
- Check Copy results to and enter
-
-
- OK