J
John
I have two columns in my Excel file. From a DB perspective let's say
I want a two column primary key (columns A and B). I have code
=IF(COUNTIF(column_name,A1)>1,"Duplicate","")
which will show if a value is a duplicate in column A. If I want to
see if the combined values of column A and column B for a given row is
unique or duplicated, how would I redo the above code? So basically
if columns A and B were merged together into one column then repeat
the above compare. Thanks.
JR
I want a two column primary key (columns A and B). I have code
=IF(COUNTIF(column_name,A1)>1,"Duplicate","")
which will show if a value is a duplicate in column A. If I want to
see if the combined values of column A and column B for a given row is
unique or duplicated, how would I redo the above code? So basically
if columns A and B were merged together into one column then repeat
the above compare. Thanks.
JR