COLUMNS Function

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

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

### 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 ... Advanced Excel Exercises with Solutions PDF  