The problem is, this is a really big list, with over 11,000 rows, and deleting the rows manually will take way too long. 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. |