Return the relative position of a specified item in a range

=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Count the number of characters in a string

LEN(text)

Sum (add) values in a range that meet multiple specific criteria.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Return the logical value TRUE if a cell contains the #N/A error

=ISBLANK(value)

Find specific text and its related starting position within a text string.

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

Round a number up to the next multiple

=CEILING(number, significance)

Return the year, month or day component of a date

=YEAR(serial_number), =MONTH(serial_number), =DAY(serial_number)

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])

Returns the character specified by a number

CHAR(number)

Return TRUE or FALSE statements based on testing multiple logical conditions

=AND(logical1, [logical2], ...)

Count values in a range that meet multiple specific criteria.

COUNTIFS(range1, criteria1, [range2], [criteria2], ...)

Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

Count values in a range that meet a single criteria.

COUNTIF(range,criteria)

Return the serial number of a particular date

=DATE (year, month, day)