How to edit a drop-down list in Excel, depending on how you created it

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.
Hosted on MSN

I use Excel's TAKE and DROP to make top-10 lists that update themselves

Creating top-10 lists in Excel can be tedious if you make them the way I used to. I'd sort the data manually, copy the highest values, and paste them into a separate section. It worked fine, but every ...
Ars Technica

merge multiple lists in excel

I'd like to find a way to merge information from mutiple data sources in excel. I've got a number of server reporting tools (HP CIM, custom scripts, SMS), that give me different pieces of information ...