在Power Pivot里，有两个很相近的函数，一个是FIND，一个是SEARCH，使用上也基本一样，比如：

A peak element is an element that is greater than its neighbors.

Suppose an array sorted in ascending order is rotated at some pivot unknown to you beforehand.

Suppose an array sorted in ascending order is rotated at some pivot unknown to you beforehand.

Given a non-empty array of integers, every element appears three times except for one, which appears exactly once. Find that single one.

Given a binary tree containing digits from 0-9 only, each root-to-leaf path could represent a number.

Find the total area covered by two rectilinear rectangles in a 2D plane.

Given a string s, you are allowed to convert it to a palindrome by adding characters in front of it. Find and return the shortest palindrome you can find by per...

Find the kth largest element in an unsorted array. Note that it is the kth largest element in the sorted order, not the kth distinct element.

Find all possible combinations of k numbers that add up to a number n, given that only numbers from 1 to 9 can be used and each combination should be a unique s...