So I have two lists (A and B) of concatenated customer #'s and material #'s (to create unique identifiers) copied/pasted to values and formatted as text.
List A is on a tab called "CPI" in cells X2 through X42766
List B is on another tab "New" in cells A2 through A202
I want to make sure that all of the records on list B are accounted for on list A... so I thought a simple COUNTIF would work.
=COUNTIF(CPI!$X$2:$X$42766,New!A2)
... but I'm getting some strange results. For instance, one of the cells is returning a "7", but when I use the excel "find all" function on column "x" of the CPI tab for the same value, excel only finds 1 result.
can anybody tell me what I've done to confuse COUNTIF? Is it something screwy about storing #'s as text maybe?
List A is on a tab called "CPI" in cells X2 through X42766
List B is on another tab "New" in cells A2 through A202
I want to make sure that all of the records on list B are accounted for on list A... so I thought a simple COUNTIF would work.
=COUNTIF(CPI!$X$2:$X$42766,New!A2)
... but I'm getting some strange results. For instance, one of the cells is returning a "7", but when I use the excel "find all" function on column "x" of the CPI tab for the same value, excel only finds 1 result.
can anybody tell me what I've done to confuse COUNTIF? Is it something screwy about storing #'s as text maybe?