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:

We’re bringing Excel and technology to Christmas!
In this video I show how Excel can choose the right image based on the contents of a cell.

Thanks to Mynda Treacy for her blogpost that shows how Excel validation can be used to limit the number of entries in a list, and she used a Christmas example.

Let’s have more fun and use Excel to anticipate if a child is going to be visited by Santa or by Krampus. The file can be downloaded here:
http://datascopic.net/wp-content/uploads/2014/09/Naughty-Nice-Ometer.xlsx