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...
Nesta página do site você pode assistir ao vídeo on-line Array Formula for Filtering Unordered Data duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Excel On Fire (Oz du Soleil) 12 Janeiro 2015, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 350 vezes e gostou 6 espectadores. Boa visualização!
![[AYA] How to farm Aya (Fast and efficiency)](https://image.4k-video.ru/id-video/ZRYHbeJsAP4)
