Learn how to create a drop down list in Excel in this step-by-step tutorial. We’ll firstly teach how to create a drop down list with a selection from the days of the week. Then, we’ll also explain how to create a smaller drop down list with only two options: yes and no. By the end […]
How to Create a Drop Down List in Excel (Step-by-Step) Read More »
Sometimes you may need to summarise your dataset by combining the rows with the same ID. In this tutorial, we will look at the following three methods you can use to combine the rows with the same ID: How to use the Excel Consolidate tool to combine rows in Excel The Consolidate tool summarizes data
Excel Combine Rows with same ID (3 Simple Methods) Read More »
In the default settings of Excel, when a dataset that has blank rows is sorted, blank rows are consigned to the end of the dataset. Sometimes you may want to override this behaviour by ignoring the blank rows when sorting data. In this tutorial we will look at the following three methods we can use
Excel Sort & Ignore Blanks (3 Methods Step-By-Step) Read More »
Sometimes when you get raw Excel data, you will find that text, numbers, and non-alphanumeric characters are all mixed up and you will need to remove the non-alphanumeric characters before you can work with the data. One way to remove the non-alphanumeric characters would be to go through the dataset cell by cell and delete
Remove Non Alphanumeric Characters in Excel Read More »
There are situations in Excel where you would want to count values in one column based on criteria in another column or columns. For example, you may want to find out from your dataset how many manufacturers of different products are based in certain regions of the country. Some of the ways of counting values
COUNTIF Based on Another Column (4 Methods) Read More »
The COUNTIF function counts the number of cells within a given data range that meet specified criteria or conditions. The COUNTIF function can also return the number of cells that contain text values that partially match the criteria value. We will use the following dataset to demonstrate how the COUNTIF function can be used to
Excel COUNTIF Partial Match (With Examples) Read More »
The VLOOKUP (Vertical Lookup) function is one of the powerful Excel functions that is used widely by many people every day. It is normally used to look for a single matching value in the first column of a table and return a single value in the same row from a different specified column. However, in
Use Excel VLOOKUP to Return Multiple Values Vertically Read More »
You are given an Excel file dataset to work on and you discover that it has so many unnecessary parentheses. How do you remove parentheses in Excel? You may decide to remove them one by one by selecting and deleting them using the delete key, but this would be tedious and quite time-consuming, especially if
Remove Parentheses in Excel (4 Simple Methods) Read More »
The Excel COUNTIFS function is used to get the number of cells in a range or ranges that meet a specified set of conditions or criteria. Sometimes you might experience countifs not working as expected and it returns a #VALUE! error, 0, amessage indicating that there is an error in the formula or some other
COUNTIFS Not Working (8 Reasons and Solutions) Read More »
If you need to apply the accounting number format in Excel, it is very similar to the Currency format and can be applied to any list of numbers where needed. The difference between the Accounting format and the Currency format is that the Accounting format will add the dollar sign on the far left and
How to Simultaneously Apply Accounting Number Format in Excel [Step By Step] Read More »
