Skip to main content

Posts

Showing posts from November, 2021

New Article

How to SUM by matching partial text in Excel

Join two or more cell values into one Cell in Excel 2016

In this tutorial you will learn, how to join, combine or merge cell values from two different cells or more than two different cells into one single cell in Excel 2016. There are many ways to combine or merge two cell values into one cell in Excel. In this tutorial I will explain 3 ways that will let you join data from several columns into one without losing data. These are CONCATENATE Function , Custom Formula and Flash Fill .     A. CONCATENATE Function to Combine Two or More Columns into One: If you have a data table with "First Name" and "Last Name" like below image and you want a new column where "First Name" and "Last Name" will combine row by row with a space into one, then follow the below steps: 1. In C3 cell enter this formula: =CONCATENATE(A3," ",B3) 2. Press Enter. CONCATENATE Function joins the cell values. In this example CONCATENATE Function first joins A3 cell value, then a space between a quotation marks (" ...

Remove Duplicate values but keep one value in excel 2016

Remove duplicate values but keep one value: So, In Microsoft Excel when you start data analysis based on one column, it is very important to keep your data clean and must follow the data table rules. Otherwise your query on data table will show you wrong result. One of the data table rule is, every record or row will be unique based on one column. In Microsoft Excel you can check and remove duplicate values or rows based on one column. This feature in Microsoft Excel is called Remove Duplicate. It is a built-in tool of Microsoft Excel which helps you to clean up your data quickly. It is very easy to use. In this tutorial I'll show you how you can remove duplicates rows in excel and keep first record or row only from each duplicate records or rows based on one column. How to use Remove Duplicate in Excel 2016 Let's start with a simple example here. Below is a data table where few columns contains duplicate values. We can remove these duplicate values but keep the first value bas...

Learn How to Use AutoFill in Excel to Save Time on Worksheet

In Excel, you often work with a data table for data analysis. While working on data table, you my need to populate your data table through importing or manually entering them which is called data typing. It is true that, this will take time. But do you know that, there are few features in Excel which allows you to auto fill up your data table?. Yes, there are few features available in Microsoft Excel which allows you to auto fill your data table and save time while working on worksheet. Such as, One Input Data Table , Two Input Data Table , Goal Seek , AutoFill etc.   In this lesson, I'll help you to learn how to use AutoFill in Excel and save your time. It is very simple to use. Just a double click you need to do it. AutoFill is really a powerful tool in Microsoft Excel. It will populate your data table in seconds and save your time while working on worksheet.   AutoFill is a great feature in Microsoft Excel which allows you to fill series of numbers, dates and other data...