COLUMNS Function Archives - Page 3 of 5

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

Feb 28, 2023

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

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

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

Apr 9, 2022

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

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

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

Feb 8, 2023

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

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

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

Sep 25, 2022

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

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

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

May 26, 2022

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

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

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

May 17, 2023

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 Columns for VLOOKUP in Excel (2 Methods)

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

Apr 27, 2023

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 Count Non Blank Cells with Condition in Excel (6 Methods)

How to Convert Single Columns to Rows in Excel with Formulas

Feb 12, 2023

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 Single Columns to Rows in Excel with Formulas

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

Feb 12, 2023

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 Convert Multiple Columns into a Single Row in Excel (2 Ways)

How to Sort by Name in Excel (3 Examples)

Apr 26, 2023

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 Sort by Name in Excel (3 Examples)

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

Feb 20, 2023

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 Calculate Total Row and Column in Excel (4 Methods)

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

May 22, 2023

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 Create Drop Down List with Filter in Excel (7 Methods)

How to Use Excel Table Reference (10 Examples)

Feb 16, 2023

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 Table Reference (10 Examples)

How to Use ADDRESS Function in Excel (7 Suitable Examples)

Jun 1, 2023

In this article, we will learn about the ADDRESS function in Excel. We will also explore how to return cell value by address, cell address instead of ...

How to Use ADDRESS Function in Excel (7 Suitable Examples)

Excel Find Last Column With Data (4 Quick Ways)

Feb 9, 2023

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