Category: Math and Trig

Dynamic selection list

Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read...

Validation based on another Validation

Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be...

Sort list dynamically (functions)

Sorting a list automatically using formulas, with no need to press the sort command Also if the source table is changed, the destination table will...

Progress bar in pure functions

This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress...