The Ticket Challenge from Wyn Hopkins | Convert a matrix into 2 columns using dynamic arrays
This video includes the weaving together of 7 dynamic array functions in the creation of a solution.
Wyn Hopkins, fellow Microsoft Excel MVP, presented a challenge recently:
If you have a list of people and their ticket numbers:
Lisa Tickets: 300-303
KC Tickets 390-390
Aaron Tickets 772-778
How can you get a list of the individual ticket numbers alongside the name of the ticket holders? E.g. 4 rows for Lisa with tickets 300, 301, 302, 303.
I show you a solution using:
FILTER, SEQUENCE, TOCOL, TEXTBEFORE, TEXTAFTER, HSTACK, VSTACK
#excelchallenge
#DynamicArrays
#exceltutorial
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2