BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.

Your typical Excel workbook—the file you're working in—can get loaded with plenty of worksheets (each indicated by a tab at the bottom, which you can name). Hide a sheet if you want, rather than ...