4 Ways to Sort Drop Down Lists Automatically in Excel
Автор: Excel Campus - Jon
Загружено: 2019-02-08
Просмотров: 90243
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: