Array Formula for Filtering Unordered Data
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...
En esta página del sitio puede ver el video en línea Array Formula for Filtering Unordered Data de Duración hora minuto segunda en buena calidad , que subió el usuario Excel On Fire (Oz du Soleil) 12 enero 2015, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 350 veces y le gustó 6 a los espectadores. Disfruta viendo!
![[AYA] How to farm Aya (Fast and efficiency)](https://image.4k-video.ru/id-video/ZRYHbeJsAP4)
