Quirky functions - functions that are fun to use
There is plenty of reference material around telling you what Excel functions do, so I'm not going to do an exhaustive list. Instead I'm going to pick out a few interesting ones and demonstrate some of the more unusual ways to use them, again always building on what we've looked at so far.
- SumProduct Strangeness-1 - for prioritizing lookups
- Sumproduct Strangeness-2 - using alongside Search()
- Respect a Filter with Sumproduct
Search (and FIND)Match
For more tips like this see Get Started Snippets.For help and more information join our community, follow the blog, follow me on twitter, or follow me on g+