In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis skills today ...

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.