COLUMNS Function Archives - Page 2 of 4

COLUMNS Function

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

Apr 9, 2022 Advanced Excel

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)

Aug 8, 2022 Advanced Excel

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)

Sep 25, 2022 Excel Formulas

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

May 26, 2022 Advanced 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)

Sep 26, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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

Jun 20, 2022 Excel 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)

Sep 18, 2022 Excel Formulas

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)

May 23, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

May 22, 2022 Advanced Excel

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)

May 22, 2022 Excel Basics

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)

Sep 18, 2022 Excel Functions

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)

May 18, 2022 Excel Basics

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)

May 23, 2022 Excel Formulas

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 ...