4 Ways to Sort Drop Down Lists Automatically in Excel

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

Learn 4 ways to sort drop-down lists automatically in Excel when changes are made to the source data.
Download the sample file: https://www.excelcampus.com/tips/sort...

This video is based on a question from Suliman, Wim, and Colin from my previous video on automatically updating drop-down lists (data validation lists).

I explain the following 4 ways to automatically sort data:

1. VBA Macro
2. Free List Search Add-in
3. Power Query
4. Dynamic Array Formulas and Spill Ranges

There are many ways to go about sorting data automatically. I chose these four techniques because at least one solution should be available to everyone, regardless of which Excel version you are using.

Here are additional resources and videos on drop-down lists:

How to Add New Items to Excel Drop-down Lists Automatically:    • Add New Items To Excel Drop-down Lists Aut...  

How to Create Drop Down Lists in Cells - The Complete Excel Guide:    • How to Create Drop Down Lists in Cells - T...  

Searchable Drop Down Lists in Excel - The List Search Add-in:    • How To Search Drop Down Lists In Excel Usi...  

Excel Drop-down List Arrow Always Visible:    • Keep Your Excel Drop-down List Arrow Alway...  

New Excel Features: Dynamic Array Functions & Formulas that Spill:    • Dynamic Array Functions Are The Best New E...  
00:00 Introduction
01:01 VBA Macro
04:07 Will work for Mac & Windows desktop version of Excel
04:18 Free List Search Add-In
06:36 Available on Windows versions of Excel (2007 or Later)
07:01 Power Query
11:00 Available on Windows versions of Excel 2010 or later
11:14 Synamic Array Fucntions