Excel Dynamic Arrays with XLOOKUP & Form Controls (Radio Buttons and Tick Boxes)
One way to get good with Excel is to play with it. In this video I decided to play with Dynamic Arrays and Excel’s form controls.The result is a pretty neat solution with tick-boxes and radio-buttons that allow the user to toggle a dataset between sorting ascending and descending.This video includes:
– XLOOKUP
– Tick Boxes
– Radio Buttons
– SORT
– FILTER
– IFERROR
#DynamicArrays
#XLOOKUP
#ExcelFormControls
For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: https://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2