Excel Dynamic Arrays with TOCOL and VSTACK
TOCOL function in MS Excel allows for any single data range of text to combine into one column of data in a dynamic list. It also has the ability to filter out criteria. VSTACK may do multiple arrays though lacks the criteria filter. See how to combine them to do both!
See the first video in this Shorts Series creating a dynamic array gathering from two worksheet sources.
• Excel - Master the VSTACK Formula
See the 3rd video alphabetizing dynamic (spilled) data.
• Excel - Sort Function with Dynamic Arrays