Getting the Most Filled Out Cells to the Top – Sort and Filter
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet.
For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet.
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet. For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet. Read More