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

[nikkim45]

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. 

[#2]

@nikkim45 

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.

I hope this helps you.

[#3]

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

[#4]

@nikkim45 

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.

[#5]

@dscheikey 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. 

[#6]

@nikkim45 

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: