Category: Formulas – combined functions

Two or more functions = One Formula, how to combine more than one function to present a powerful formula that does the job well

Middle name + 1st name

Jan8 date format

Walking Columns

Get 3rd Wednesday of month

Repeated Offset

Sorting with functions only

6174 Kaprekar’s constant

Cuts string of list of items

Excel @ before function names in formulas

Return 12 values in one number

Searching table in 2 dimensions.