Excel Dynamic Arrays: FILTER for Optional and Required Fields
1,847 views · Published 7 December 2018 · 6:46 · Indexed 14 October 2026
Channel: Excel On Fire (Oz du Soleil) · 2018 · Education
The new FILTER function is fantastic, but I wondered how can I make an optional field? Sometimes we do searches and want to look at items between $10 and $100 for brand X. We also want to look at everything between $10 and $100 regardless of the brand. That's what I wanted to replicate with the FILTER function: an optional filter. The straight-forward FILTER function forces us to filter for something whether we want to, or not. My solution involves using an IF statement and smart use of the # nomenclature. Check it out! #DynamicArrayFunctions #OptionalFilter For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course: https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2
More from this channel
-
5:03
Basic Excel Table Demo
-
10:28
Generating Random Data to Set Up a Pivot Table Tutorial
-
4:13
slicers and pivots to determine trip destination
-
8:23
Excel Data Validation: Why It's Important
-
3:41
Excel demo: retrieving current and historical stock data from the web.
-
5:45
Sriracha Taste Test 2: Sky Valley, Saigon Sisters & Lee Kum Kee
-
9:18
converting columnar data to sortable rows
-
5:09
The Power of Excel & Data: Oz at IgniteChicago