S S Jul 9, 2004 #1 I would like a formula that will take column a data and match it (yes/no) on column b data. Any ideas?
I would like a formula that will take column a data and match it (yes/no) on column b data. Any ideas?
F Frank Kabel Jul 9, 2004 #2 Hi you may provide some more detail. Do you mean something like =IF(COUNTIF($A$1:$A$100,B1)>0,"Yes","No") and copy this down for all rows
Hi you may provide some more detail. Do you mean something like =IF(COUNTIF($A$1:$A$100,B1)>0,"Yes","No") and copy this down for all rows
H hgrove Jul 9, 2004 #3 S wrote... I would like a formula that will take column a data and match it (yes/no) on column b data. Click to expand... ... Column A would match column B perfectly? Everything in column A als appears in column B but not necessarily in the same order but an duplicates match up? Everything in column A appears at least once i column B? What *precisely* do you mean by 'match'
S wrote... I would like a formula that will take column a data and match it (yes/no) on column b data. Click to expand... ... Column A would match column B perfectly? Everything in column A als appears in column B but not necessarily in the same order but an duplicates match up? Everything in column A appears at least once i column B? What *precisely* do you mean by 'match'
