COLUMNS Function Archives

6 Ways to Extract Data from Excel Based on Criteria

April 5, 2023

There may be times when you need to know how to extract data from Excel based on criteria. For example, you may need to use an Excel formula or VBA ...

2 Ways to Count Columns for VLOOKUP in Excel

March 23, 2023

Sometimes we want to count the column number in excel for VLOOKUP.For a simple dataset, counting column numbers is simple.However, as the column ...

4 Ways to Combine Columns into One List in Excel

January 2, 2023

If we have our desired data indifferent columns in an excel file and combine them in a list. In that case we can cut and paste them into the desired ...

Excel Formula: Use VLOOKUP Function with Multiple Sheets

April 3, 2023

The VLOOKUP function is basically used to search values vertically, and it’s a very easy and useful tool in Excel. This article will discuss how to ...

8 Ways to Arrange Numbers in Ascending Order in Excel Using Formula

March 20, 2023

We can use Microsoft Excel for arranging numbers in ascending or descending order by using SORT from the toolbar or just creating a table and then ...