Checking For Duplicate Values Within A Range



Columns A & B contain two lists of values.
We want to create a formula that will check whether there is any duplication of values within either list (blank cells are to be ignored).


Use the COUNTA, SUMPRODUCT, and COUNTIF functions as shown in the following formula:

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>