Uploaded May 2017 | Updated September 2026, 53 minutes ago

---

0:00 Challenge Intro
0:06 ASK QUESTIONS TO GET MORE DETAILS!
0:41 Remove Duplicates & Sort
1:16 Pivot Table
2:42 Array Formula
3:19 Non Array Formula (helper columns)
8:29 Recap

MY POST
myspreadsheetlab.com/video-00159-create-unique-and-sorted-text-list

OSCAR CRONQUIST's POST
get-digital-help.com/2009/05/25/create-a-drop-down-list-containing-only-unique-distinct-alphabetically-sorted-text-values-using-excel-array-formula

DAVID HAGAR's POST
dhexcel1.wordpress.com/2017/04/01/generating-a-sorted-unique-array-in-excel-using-only-formulas-by-david-hager

MIKE GIRVIN's VIDEO
youtu.be/IZZPnsRD90c