Found 1263 Articles for Computers

If you want to compare two or more columns to find duplicate values, it can be done using a formula mentioned in this article. Many times, we come across a data set where values are entered repeatedly and required to be filtered. Let’s see how this can be achieved. Compare Two or More Columns Using a Formula Step 1 − We have taken sample data as shown below having two columns with some duplicate values. Step 2 − In the column C, we will identify the duplicate and unique values using the below formula. IF(ISERROR(MATCH(B3, $A$3−$A$10000, 0)), "Unique", ... Read More

To compare the values of two or more cells there are multiple formulas that can be used. For example, MATCH, If(A=B), EXACT, COUNTIF, etc. Here we will be learning the following two functions to find the exact match or where the formula will compare the strings without considering the case of strings. EXACT − To find the exact match. COUNTIF − To find similar values. Compare Multiple Cells for Equal Values Step 1 − Following is the sample data that we have taken for comparing the strings/cell values in a datasheet. Step 2 − Here, we have ... Read More

If we want to compare a date in an excel sheet with all other dates available in the sheet, then manually doing this activity will be very tedious and time taking. For this activity, we can use a formula that may give the comparison in one shot. Let’s learn how to use this formula to compare the dates. Compare Dates to Check if a Date is Greater than Another Date Step 1 − Below is the sample data that we have taken for comparing the dates. In the first column, we have taken the dates with which comparison needs to ... Read More

It usually happens with huge data that we might get multiple workbooks having worksheets of same name. Due to this we need to check all the similar sheets to get any specific value related to that sheet name. In this article, we will learn how to merge the worksheets having same name. By using the following method, we can combine the worksheets of same name into a master worksheet. Combine worksheets of same name into one worksheet using Copy and Paste command Step 1 − Here we have taken the sample data in two separate workbooks having sheets with same ... Read More

Introduction Machine learning is indeed the idea that different technological tools, such as computers and tablets may understand anything dependent on coding along with other data. Although it looks like something from the future, most people use the internet on this level every day. Speaking recognition is a fantastic example of this. The technology is used by virtual personal assistants such as Siri and Alexa to read out reminders, respond to enquiries, and carry out tasks. More experts are considering employment as machine learning experts, as the sector grows. Making a project from start to finish is among the best ... Read More

Maintaining the value of a particular item at every instance of time is a very crucial process if the prices of the item change very frequently. If we want to note the value of an item in particular intervals, then we need to create a list that contains the time with hours/minutes/seconds increment. For example, such a list is quite useful in case of stock prices because they change rapidly. Although we can’t note every value, we can note the value for all particular intervals, like for every 15 minutes, to analyse its change of price. How to Add Time ... Read More

An email address of a person, in most cases, is generally a combination of the first and last name, ending with the host details such as @gmail.com, @yahoo.com, etc. Suppose we have an Excel sheet with two columns containing the first and last names of employees, then we can easily append their email addresses in a third column, by combining the data values of the first two columns. Adding Email Address to a List of Names We can follow a simple process to add email addresses to a list of names. Basically, this process contains two parts, the first step ... Read More

Let's suppose you need to add a particular text string in all the cells of an Excel sheet at the beginning or end of the existing data. It can be a tedious process if you decide to perform this such a task manually. In this tutorial, we will show you a simple method by which you can do it using a formula in Excel. We can add text in beginning or end using the same formula but the process is sequence of the work is different. Let us see the simple process to add text in bigging or end of ... Read More

Suppose you have an Excel sheet with a column of data and you need to add a string of text at a specific position in all the column data. In such cases, you don't have to type the entire data all over again to update the given column data. In this tutorial, we will demonstrate in a few simple steps how you can add the new data in between an existing set of data. Add Text in the Middle of Selected Cells in Excel Suppose we have an Excel sheet with a list of data that starts with the letter ... Read More

When we have two separate columns in an Excel sheet which are to be combined, you don't have to create a new column and enter the whole data again. In this tutorial, we will show you two different ways to combine text cells together into one cell. You can either used the Ampersand symbol (&) or the CONCAT function for this purpose. We will take a simple example to demonstrate how it is done. We will take to columns that would contain the "first name" and "last name" of a set of people. Then, we will create a new column ... Read More