Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.

Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.

Guy joined Scientific Data in October 2021. Prior to that he was the Executive Editor for Data at the Royal Society of Chemistry with responsibility for managing chemical databases and setting ...