Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
CHOOSEROWS
When working with tabular data in Excel, there are often times we need to extract specific rows or columns based on custom logic. This is where the CHOOSEROWS and CHOOSECOLS functions come into play. These recently introduced dynamic array functions are powerful alternatives to functions like TAKE and DROP, offering more flexibility by letting us…