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.

Combine INDEX and MATCH: Use MATCH to find the row or column number and INDEX to retrieve the value at that position.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

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.

Tips The fill handle method works for both columns and rows, while the copy and paste method can be used to populate a row, column or even an entire block of cells with the same value.

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button.