COLUMNS Function

Create Excel Filter Using Drop-Down List Based on Cell Value

A drop-down list filter is basically a list of unique names. If you select any of the items from the drop-down list, you will get the corresponding ...

Excel Data Validation Drop Down List with Filter (2 Examples)

In this article, I will discuss how you can filter excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter ...

INDEX-MATCH with Multiple Criteria for Partial Text in Excel (2 Ways)

In this article, we will learn to use the INDEX-MATCH Formula with multiple criteria for partial text. We use INDEX and MATCH Functions to look up ...

Creating a Drop Down Filter to Extract Data Based on Selection in Excel

The Filter feature in Excel helps us to extract data according to our selections. But the problem with the feature is that the row numbers and the ...

How to Count Columns for VLOOKUP in Excel (2 Methods)

When we use the Excel VLOOKUP function, we have to input the Column number from which it’ll return the data. But, manually counting the column number ...

How to Count Non Blank Cells with Condition in Excel (6 Methods)

While dealing with a large Microsoft Excel, sometimes we need to count non-blank cells with several conditions. In our Excel worksheet for the ...

How to Convert Single Columns to Rows in Excel with Formulas

In this article, I will show how to convert single columns to rows using excel formulas. Basically, when we copy data from any word editor to excel, ...

How to Convert Multiple Columns into a Single Row in Excel (2 Ways)

In Microsoft Excel, converting multiple columns to a single row is one of the familiar tasks. You will find yourself in a lot of situations where you ...

How to Sort by Name in Excel (3 Examples)

In Excel, as you add more information to a worksheet, it becomes increasingly critical to organize it. Sorting your data can help you rapidly ...

How to Calculate Total Row and Column in Excel (4 Methods)

While working with a large worksheet in Microsoft Excel, we need to sum up cells in Excel. To sum, cells values mean total columns and rows value, MS ...

How to Create Drop Down List with Filter in Excel (7 Methods)

In Microsoft Excel, data entry becomes faster when we use a drop-down list filter. Filters may be used to filter down and conceal sections of our ...

How to Use Excel Table Reference (10 Examples)

If you are looking for some of the easiest ways to use Excel Table reference, then you are in the right place. Using Table references you can perform ...

How to Use Excel ADDRESS Function (7 Examples)

The ADDRESS function in MS Excel is under the Lookup and Reference functions category. We use the ADDRESS function to get the address of a cell (e.g. ...

Excel Find Last Column With Data (4 Quick Ways)

In a large worksheet, finding the last column with data manually is time-consuming and not friendly. There are some functions by using which you can ...

How to Check If a Value is in List in Excel (10 Ways)

If you are looking for some of the easiest ways to check if a value is in a list in Excel, then you are in the right place. To check out your desired ...

ExcelDemy
Logo