Array Formula for Filtering Unordered Data

Published: 12 January 2015
on channel: Excel On Fire (Oz du Soleil)

350

It's one thing to search/sort/filter for specific, orderly attributes (e.g., a coat has a size, a price, a color and a season). But what if you need to get at data that has attributes that aren't in any order?

Example:
Drink A = Whiskey, Basil and Coffee
Drink B = Whiskey, Orange Juice and Lime
Drink C = Coffee, Whiskey, Cointreau and Cayenne Pepper.
Drink D = Frangelico, Lime, Basil

How do you filter for the drinks that have both Whiskey and Coffee? It would be inconvenient to get the ingredients lined up.

This video shows a solution and I will follow up with a more detailed blogpost. Until then, you can download the file here:
http://datascopic.net/ArrayFormulaFil...

On this page of the site you can watch the video online Array Formula for Filtering Unordered Data with a duration of hours minute second in good quality, which was uploaded by the user Excel On Fire (Oz du Soleil) 12 January 2015, share the link with friends and acquaintances, this video has already been watched 350 times on youtube and it was liked by 6 viewers. Enjoy your viewing!

262