Forum Discussion
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 ou...
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.
- 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
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.
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.
