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

• SumProduct Strangeness-1 - for prioritizing lookups
• Sumproduct Strangeness-2 - using alongside Search()
• Respect a Filter with Sumproduct
  

Search (and FIND)

Match

• Leveraging sorted data with Match
• Using match to categorize
  

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+