Shulou(Shulou.com)06/02 Report--

This article mainly introduces the use of ifcountif function to find two repeated methods, with a certain reference value, friends can refer to the need. I hope you all have a lot of success after reading this article. Let's take a look at it together.

Use the ifcountif function to find two duplicate columns: first open the table file to be filtered; then enter the formula "=countif(C:C, B:B)" in the space and press Enter; finally press the shortcut key "ctrl+shift+L" to open the filter.

The countif function filters duplicate data. The advantage is that it can quickly filter huge data. At the same time, two columns of data can be sorted one by one, which is more accurate and convenient to check.

As shown in the figure, we now want to filter out the duplicate data in data A and B. if we filter with conditional format, we will be confused by that duplicate data in the column A, so that the resulting data is inaccurate.

So we use the function "countif." As shown in the figure, take another column of "filter." Type "=countif (C:C, B:B)" in the space and press Enter. Here, we should pay attention to the order of selecting the series, because we want to filter out "data A", so we need to give priority to "data B", that is,"C:C" in parentheses is in front.

Then move the mouse to the lower right corner of the grid, double-click the left mouse button. This will automatically duplicate the function. as shown in the figure.

Then move the mouse to the leftmost serial number "1" and quickly select the first row. Then press the shortcut key "ctrl+shift+L" to open the filter. as shown in the figure.

Then click on the "triangle" in the filter column. As shown in the figure, check the option "0" and press the confirm key.

The final selection is the duplicate of "Data A" and "Data B." You'll see here that the number "2" is displayed because there are two identical data in the corresponding row of "data B." If there are three identical ones,"3" will be displayed.

Thank you for reading this article carefully, I hope Xiaobian share the use of ifcountif function to find two columns of repeated method content is helpful to everyone, but also hope that everyone more support, pay attention to the industry information channel, encounter problems to find, detailed solutions waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.