I've seen a drop down list on an excel speardsheet that includes top10, all,
blanks, sort ascending and also adds to the list everything entered in the
column below.

I can create a basic dropdown with data validation, but how do I include
these other features?

Thanks