The data and workbook are very straightforward.
For purposes of illustration, let's say the first sheet includes one column the numbers 1-10 sequentially, one number each in the first 10 rows of column A.
I.E. Row one has the number 1, row two has the number 2, etc.
The second sheet has one column column containing the numbers 5-15, starting with the number 5 in row 1, 6 in row 2, etc.
The task is to identify numbers which appear in sheet one, but which do not appear in sheet 2
Need to figure out if my formula =COUNTIF(mySheet1datacolumnName, should end in A1>0 or $A2, or something else.
I got the best results with =Countif(CC_data1,$A2) this seems to identify some, but not all dupes or uniques so Im guessing there is a small error
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!