COLUMN Function

How to Insert Date in Excel (7 Simple Methods)

There are several purposes for inserting dates in Excel; tracking any information or for any date-time calculation you need to insert dates. Today we ...

How to Change Dates Automatically Using Formula in Excel

For easing your task you may demand automatic update of date, time sequence number, etc. Excel provides you with a feature for that. Today we are ...

How to Use VLOOKUP for Rows in Excel (With Alternatives)

VLOOKUP function is generally used to look for a value in the leftmost column in a table and the function will return a value in the same row from ...

VLOOKUP to Return Multiple Values Horizontally in Excel

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

How to Use MOD Function in Excel (9 Suitable Examples)

In Microsoft Excel, the MOD function is widely used to extract the data from the series of nth rows or columns for calculation and other purposes. In ...

How to Use INDIRECT Function in Excel (12 Suitable Instances)

In Microsoft Excel, the INDIRECT function is generally applied to store a cell reference and then use the reference value with other functions to ...

How to use COLUMNS Function in Excel (3 Examples)

There are a number of functions in Excel to perform various lookup and search operations easily and swiftly. Today we are going to show you how to ...

How to Use COLUMN Function in Excel (4 Easy Examples)

Sometimes we may need to figure out or determine the column number of any specific cell. For this purpose, Excel provides a function named COLUMN. ...

Excel Sum Last 5 Values in Row (Formula + VBA Code)

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row. In this article, I’ll discuss the ...

Top 10 Values Based on Criteria in Excel (Both Single and Multiple Criteria)

Today I will be showing how you can filter out the top 10 values based on any criteria from any set of data in Microsoft Excel. How to Find ...

Return Multiple Values in Excel Based on Single Criteria (3 Options)

Today I am going to show how you can return multiple values based on single criteria in Microsoft Excel. Download Practice Workbook Return ...

Sum Every nth Column (Formula and VBA Code)

In real life scenario, you may deal with different sum operations in Excel like sum with multiple criteria, sum entire column, sum every other ...

Excel Copy Rows from One Sheet to Another Based on Criteria (5 Ways)

In MS-Excel sometimes we need to copy rows from any worksheet to another worksheet based on different criteria. In this article, I will show various ...

ExcelDemy
Logo