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

Convert 2-column into wide (column-row) table

ANmar February 9, 2012

Multiple Dual-Validations

ANmar February 9, 2012

Multiple-Validations (connected to each other)

ANmar February 7, 2012

Dynamic selection list

ANmar February 7, 2012

Validation based on another Validation

ANmar February 7, 2012

Rotate table using 1 formula

ANmar February 6, 2012

Sort list dynamically (functions)

ANmar February 5, 2012

Insert Blank rows into table using functions

ANmar February 5, 2012

Change Calculator – calculate change in multiple bills/coins

ANmar February 1, 2012

Progress bar in pure functions

ANmar January 29, 2012

Excel Dynamic Drop-Downs that grow with you

ANmar January 29, 2012