CHOOSECOLS

Slice A Range With The TAKE, DROP And CHOOSECOLS Functions In Excel A hard-coded range reference is wrong the moment somebody adds a row. TAKE, DROP, CHOOSECOLS and CHOOSEROWS count from the edge of whatever the range currently holds, and… August 28, 2026 · Excel Formulas