We could just work our way through the list, deleting those empty rows one by one. We want to remove all of the rows that don't have a Last login date. You can see that this is a list of users, and that one of the columns contains a Last login date. In today's ExcelJet tip, we'll show you a cool way to delete rows that are missing values in one step even when your list contains hundreds or thousands of rows. In a previous tip, we showed you how to delete blank rows. You could delete the rows one by one, but that will take a long time if you have a big list. Sometimes you need to remove rows from a list or a table that are missing values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |