Uploaded June 2016 | Updated September 2026, 51 minutes ago

---

Get Excel file 00149 here: http://1drv.ms/1bYwrTa
This is a challenge from Oz du Soleil. We want to dynamically sort text excluding 'A', 'An', 'The' if found at the beginning of the title.

00:00 Intro
00:29 Logic (key idea)
00:38 Oz's Solution
01:59 My high tech solution (array)
04:00 My low tech solution (manual, nor formulas!)

Download Oz's sample workbook:
datascopic.net/Kevin-Oz-Titles

Oz's book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

Oz's blog: datascopic.net

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog