-
Continue reading →: Extract Last 2 Characters in Excel: A Step-by-Step GuideA common task in data analysis is to extract parts or chunks from a string. In this example we are going to see how we can extract the last 2 characters from a string in Excel. Start by entering some data in Column A Above we have a column with…
-
Continue reading →: Delete Empty Rows in ExcelSometimes when we handle data we encounter blank rows, we can deal with them in many ways – here we are going to see how we can delete rows that are completely empty – that is all cells in the row are empty. Start by entering some example data –…
-
Continue reading →: Fill Blank Cells in ExcelSometimes we face the issue with blank cells in our data. if we have formulas involved this can cause trouble. My approach to this is to find all the blank cells, and fill them with a value, like 0 or N/A. Lets see how this can be done. Enter some…
-
Continue reading →: Using Conditional Formatting for Duplicate Values in ExcelIn the previous tutorial we used conditional formatting to highlight duplicate values in a range – we did not use a formula that time – but below I will show how we can accomplish the same thing with using a formula. Start by entering some data in column A –…
-
Continue reading →: Simple Way to Highlight Duplicates in Excel Using Conditional Formatting
In Excel there are a lot of different ways to highlight duplicates, we can use formulas in a variety of ways or we can use conditional formatting. Here in this tutorials we are going to use one of the most simple ways to highlight duplicates in a range. To illustrate…
-
Continue reading →: How to Find and Highlight Duplicates in Excel Using COUNTIF
In EXCEL there are many ways to find and/or highlight duplicates in ranges or lists. In the following example we are going to use the function COUNTIF First, enter some data in Column A, in Column B we enter a heading like “IS DUPLICATE”. Now, in cell B2, enter the…
-
Continue reading →: Excel FREQUENCYThe function FREQUENCY in Excel is a function for counting occurrences and group them into intervals. The syntax for the forumula is like this: =FREQUENCY(data_array,bins_array) data_array: This is the values you want to evaluate. bins_array: These are the categories or intervals that you are grouping the data into. it can…
-
Continue reading →: Easy Guide to Excel CONCAT Function: Combining Cell Values
A common task in Excel is to link values in cells together – to concatenate them. One way to do this is to use the =CONCAT function. To combine values from cells we will therefore use =CONCAT(). Lets try this with a simple example, open a blank excelsheet and enter…
-
Continue reading →: Excel SUM Function: How to Add Numbers in a Range
One of the most basic functions in Excel is the SUM function. The function adds numbers in a range. Lets create a simpel example to see how the function works. Enter some data in Excel – like below for example. Here we are interested in the total miles the cars…
-
Continue reading →: How to Merge or Combine Lists in Excel Using VSTACK FunctionThere are multiple ways to merge or combine lists in Excel. Here we are going to use the function VSTACK to combine 2 small lists. The VSTACK function combines arrays vertically into a single array. Start by entering some data in column A and B – they dont have to be…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 