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

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-drop-down-lists-automatically/

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: https://youtu.be/RLLdY37YUgs

How to Create Drop Down Lists in Cells - The Complete Excel Guide: https://youtu.be/KGnvCKiOLM0

Searchable Drop Down Lists in Excel - The List Search Add-in: https://youtu.be/kntHn2J7pdk

Excel Drop-down List Arrow Always Visible: https://youtu.be/oHtVmvqgZEM

New Excel Features: Dynamic Array Functions & Formulas that Spill: https://youtu.be/1HF0UGMF070
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