This formula will return the relative position of the minimum value in a given range of numerical values. The formula will work for any one dimensional vertical or horizontal range. If the range contains multiple minimums, then the formula will return the position of the top most or left most minimum.

This formula will return the relative position of the maximum value in a given range of numerical values. The formula will work for any one dimensional vertical or horizontal range. If the range contains multiple maximums, then the formula will return the position of the top most or left most maximum.

This formula will count the number of cells in a given range which contain exactly N characters.

Example =ISREF(INDIRECT("'"&B3&"'!A1")) Generic Formula...

This formula will generate a random letter or symbol.

This formula will return the domain from a given email address. For example the domain of “yourname@yourcompany.com” would be “yourcompany.com”.