I have a spreadsheet with 51000 entries. If column M AND column O are both empty on any row, I can delete that row.
How can I sort my spreadsheet to have any row with this specific requirement drop to the bottom of the spreadsheet?
I don’t want to delete the rows right away in case my supervisor changes his mind.
Use a helper column adjacent to the range of columns you want to sort, but otherwise unused, enter the formula =AND(M1="";O1="")
(or similar) into row 1 (or respective) and fill it down for as many rows as your data occupy. Then sort the complete range ascending, using the helper column as the only key.
Use autofilter for all range and select “Empty” in drop-down menu in M and O headers