In this article we will learn how to find the duplicate items in combined columns. To find duplicate items we use the “COUNTIF” and “IF” formulae in Microsoft Excel.
IF:-IF condition allows us to specify multiple conditions in a cell. It helps us to create the flexibility of the function in Microsoft Excel . Upto a maximum of 64 conditions can be placed inside an IF function.
Syntax of “IF” function: =if (logical test, [value_if_true], [value_if_false])
COUNTIFS: This function is used to return the count of same entry in the multiple range..
Syntax of “COUNTIFS” function: =COUNTIFS (Criteria_Range1, Criteria1,Criteria_Range2,Range2)
Let’s take an example and understand how we can find duplicate items in combined columns in Microsoft Excel.
Example: - We have a list of names in range A2:A28, in which one name is entered many times. We need to find all the names which are entered more than once.
To do this, follow the below mentioned steps:-
To convert the formula into value use the “Paste Special” option:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.