When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times. Be it sales data, client names, product segments, dates, or geographical ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

In this tutorial, I’ll show you how to populate a dropdown with data on another sheet. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use older .xlsx versions.