34.
LARGE
=LARGE(array, k)
Returns the k-th largest value in a data set. For example, the fifth-largest number
35. SMALL
=SMALL(array, k)
Returns the k-th smallest value in a data set. For example, the fifth smallest number
36. MAX & MAXA
=MAX(number1, [number2], [number3], [number4], …)
Returns the largest value in a set of values. Ignores logical values and text
=MAXA(value1, [value2], [value3], [value4], …)
Returns the largest value in a set of values. Do not ignore logical values and text. MAXA function evaluates TRUE as 1, FALSE
as 0, and any Text value as 0. Empty cells are ignored
37. MIN & MINA
=MIN(number1, [number2], [number3], [number4], …)
Returns the smallest number in a set of values. Ignores logical values and text
=MINA(value1, [value2], [value3], [value4], …)
Returns the smallest value in a set of values. Do not ignore logical values and text. MAXA function evaluates TRUE as 1,
FALSE as 0, and any Text value as 0. Empty cells are ignored
38. MOD
=MOD(number, divisor)
Returns the remainder after a number is divided by a divisor
39. RAND
=RAND()
Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation)
40. RANDBETWEEN
=RANDBETWEEN(bottom, top)
Returns a random number between the numbers you specify
41. SQRT
=SQRT(number)
Returns the square root of a number
42. SUBTOTAL
=SUBTOTAL(function_num, ref1, [ref2], [ref3], …)
Returns a subtotal in a list or database
D. FIND & SEARCH FUNCTIONS
43. FIND
=FIND(find_text, within_text, [start_num])
Returns the starting position of one text string within another text string. FIND is case-sensitive
44. SEARCH
=SEARCH(find_text, within_text, [start_num])
Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-
sensitive)
45. SUBSTITUTE
=SUBSTITUTE(text, old_text, new_text, [instance_num])
Replaces existing text with new text in a text string
