If in your work routine you are faced with a situation that requires processing a large amount of data without using ink and expensive equipment, Excel will help you. This utility does a good job of building tables, graphs, charts and helps in accounting calculations. This article will detail the methods with which you can find the same values in the Excel column, which will make your work in this application much faster and better.
Color search
So, suppose you need to select the same values, names in an Excel table, to do this, do the following:
- Select the area in which the search for identical values will be performed.
- Click the Home tab.
- Go to the Styles section.
- Select Conditional Formatting.
- Next, "Cell Selection Rules."
- Then Duplicate Values.
After performing all of the above actions, a window will open in which several items are displayed:
- indicating duplicate data;
- shows what color the detected duplicates will color;
- confirmation button.
This method is very simple and effective, it will allow even the most inexperienced user to find the same values in two Excel columns.
Find and Select Function
The next method, like the previous one, is very simple and reliable in terms of finding duplicate objects. He is guaranteed to bring a positive result.
To use this very easy and effective way, you need to do a certain series of actions, namely:
- Open the Home tab.
- In the upper right corner find the "Editing" section.
- Select the "Find and Select" function.
- A small window will be displayed, at the top of which click the "Find" button.
- Enter the name of the desired value in the indicated field and click "Find All".
- Next, press Ctrl + A to highlight all found objects.
After all the steps, you can easily find duplicate values in Excel and color them in any color for the fastest search. Among other things, the function of deleting found values is available. When the amount of information is too large, but there is no time to analyze and search for it manually, this search method will become your savior in the current situation.
Advanced filter
Find the same values in the Excel column for you is still a problem? Use the advanced filter. With it, you can both detect and delete all duplicates found at once. So, to apply this method, we need:
- Select any one cell of the table we need.
- Go to the "Data" tab.
- Find the "Sort and Filter" section.
- Select "Advanced".
A window appears in front of our eyes in which we need to configure the filtering of the selected table. In addition to deletion, we can also transfer duplicates found elsewhere. For this:
- In the "Processing" section, select "Copy the result to another location" (specify the range where exactly the found values should be transferred).
- Check the box next to "Only unique data."
After completing all the above steps, you can easily find the same values in the Excel column and delete them by copying to the area you specified (only if you select the Excel column you need and do all the above operations). Among other things, you can also process data in the same place. To do this, do all the same actions, except for one - instead of the item "Copy the result to another", select "Filter the list in place."
Then go to the “Data” tab and find the section “Working with data”, there click “Delete duplicates”. Next, a small window will appear in front of your eyes, where you will need to select the necessary columns and click the "OK" button.
This method is a little more complicated than the ones mentioned above, however, with its help you can both find duplicate values in the Excel column and transfer them to another area with subsequent removal in the previous place.
Conclusion
In this article, we have examined in detail several methods with which you can select, delete, and detect duplicates in Excel. Using any of the above methods, you can certainly achieve your goals. These methods are not the only ones for finding duplicate values in a program, but they are very simple and effective compared to others. You no longer have to tediously and long search for the desired duplicate value throughout the application. Now, with just a few simple steps, you can quickly find the same values in the Excel column.