Getting the Most Filled Out Cells to the Top - Sort and Filter

Question

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.

dscheikey · Answer

nikkim45&nbsp;You need an auxiliary column! In my example F. There the date is extracted from columns C to E with XLOOCKUP(). You can then sort by this column.&nbsp;&nbsp;I hope this helps you.&nbsp;&nbsp;

nikkim45 · Answer

So how would I do this with the custom sort and filter I already have set up? I need to be able to have it with that

dscheikey · Answer

nikkim45&nbsp;I thought that if you added the additional column to your table, you would be able to filter and sort with it.To be able to help you better, I need more information. Maybe you can upload a document with sample data here. There is a field under the text field where you can store files.&nbsp;

nikkim45 · Answer

dscheikey&nbsp;I have attached a small sample of what the file I am working with is like. Once the ship date, invoice number, and comment box are full, I would like to be able to sort and filter and have those rows be at the top. I have already set the sort and filter settings up how they are on the actual file I use.&nbsp;

dscheikey · Answer

nikkim45&nbsp;I would then make a combination of the three cells as the sort and filter value. Only display these if all three fields are filled in.See my example:&nbsp;

Forum Discussion

Getting the Most Filled Out Cells to the Top - Sort and Filter

Share

Resources