COLUMNS Function

How to Create a Vertical Scroll Bar in Excel (Step by Step)

A vertical scroll bar is a tool that can help us visualize large data tables from top to bottom. Excel provides a ton of flexibility in modifying the ...

Transpose Multiple Columns into One Column in Excel (3 Handy Methods)

This article will show how to transpose multiple columns into one column in Excel using Excel formulas, VBA codes, and the Power Query tool. The ...

How to Make a Correlation Matrix in Excel (2 Handy Approaches)

A Correlation Matrix is nothing but a table that represents the related coefficients for different variables. I will try to show some suitable ways ...

How to Split Text by Space with Formula in Excel (5 Ways)

There are numerous ways to split text in Excel. In this article, we will see several methods for Excel split text by space formula. We have a sample ...

How to Separate Text in Excel (10 Easy Methods)

Often our texts are in a hard-to-read format. In this article, we’re going to show how to separate text in Excel in 10 easy methods. To demonstrate ...

How to Transpose Column to Multiple Rows in Excel (6 Methods)

The article will show you some easy methods on how to transpose column(s) to multiple rows in Microsoft Excel. Sometimes, we may need to change our ...

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

We can search match objects in Excel in different ways. There are different Excel functions, VBA codes are used to find the matching and return them. ...

How to Extract Data from a List Using Excel Formula (5 Methods)

In Microsoft Excel sometimes we may need to extract data from a range or list. This process can be done in various ways. Today in this article, I am ...

How to Split Data into Equal Groups in Excel (3 Methods)

We may face some situations while dealing with Microsoft Excel where all our data are in a column. But we need to split them into several equal ...

How to Split Data in Excel (5 Ways)

In different circumstances, we need to split our data into different pieces. These dissections of data are usually done by space, commas, or some ...

How to Hide Formula in Excel Using VBA (4 Methods)

Sometimes we want to hide formulas for certain results to make any large worksheet less crowded. Implementing VBA is the most effective, quickest, ...

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

ExcelDemy
Logo