If the Values in the List Arte the Same Drop Them Both

Many companies nevertheless use Excel equally it allows them to store unlike types of information, such as tax records and business contacts. Since many things are oft done manually in Excel, there is a potential run a risk of storing fake data. Maybe you make a typo or read a certain number wrong.

Making these kinds of mistakes can sometimes lead to very serious consequences. That's exactly why accuracy is so important when working in Excel. Thankfully, people behind Excel have thought near this problem, so they have included features and tools that help everyday users check their data and correct the errors.

This article will evidence y'all how to cheque if ii cells in Excel have the same value.

How to Bank check for Duplicate Cells using the Exact Office

If you want to check whether or not two cells have the same value simply don't want to become through the whole table manually, y'all tin make Excel practise this for you. Excel has a built-in function called Exact. This function works for both numbers and text.

Hither is how yous tin can utilize the Exact Excel function.

Let's say that yous are working with the worksheet from the motion-picture show. Equally you can come across, it isn't that easy to determine whether the numbers from column A are the same as the numbers from cavalcade B.

To make sure that cells from column A don't have a duplicate in the corresponding cavalcade B cells, use the Exact function. For example, if y'all want to bank check cells A1 and B1, you tin apply the Exact function in the C1 cell.

When you lot use this function, Excel will return a value of Truthful if the numbers match, and the value of FALSE if they don't.

1. To locate the Exact role, click on the Formulas tab and and then select the Text button.
2. Cull EXACT from the driblet-drown card, the Exact formula works on numbers as well.
3. After clicking on Exact, a window called Function Arguments volition appear. In this window, you lot need to specify exactly which cells you want to compare.
4. And then, if you want to compare cells A1 and B1, blazon "A1" in the Text1 box and so "B1" in the Text2 box and click OK.
5. Equally the numbers from cells A1 and B1 don't friction match, you will find that Excel returned a Simulated value and stored the issue in cell C1.
6. To check all the other cells, you can drag the make full handle, which is a small foursquare located in the bottom-right corner of the cell, all the style downwards. This will copy and apply the formula to all the other cells. Later you have done that, you should notice the FALSE value in C6, C9, C11, and C14. The balance of the cells in the C column are marked every bit TRUE because the formula found a friction match.

How to Check for Duplicate Cells using the IF Office

Another role that allows yous to compare two cells is the IF function. It compares the cells from a cavalcade row by row. Permit's use the aforementioned two columns (A1 and B1) equally in the previous instance.

To use the IF function correctly, y'all volition need to remember its syntax.

1. In cell C1, type the following formula: =IF(A1=B1, "Lucifer", " "), yous'll run into Match next to the cells that do.
2. On the other hand, if y'all want to bank check for differences, you should type the following formula: =IF(A1<>B1, "No match"," "), once more drag the fill up handle down to apply the function to all cells.
3. Excel also allows you lot to bank check for both matches and differences in the aforementioned formula. All that yous need to exercise is type either =IF(A1<>B1, "No friction match", "Match") or =IF (A1=B1, "Friction match", "No match").

Check for Duplicates and Correct Mistakes

These are the easiest methods to find out whether two cells take the same value in Excel. Of course, there are other, more than complex methods that can exercise the same, but these two should be enough for everyday users.

Now that you know how to await for duplicates in your Excel worksheet, you tin can hands gear up errors and make sure that you accept entered the correct information.

zieglerwheady.blogspot.com

Source: https://www.alphr.com/two-cells-contain-same-value/