coolcarnee
New Member
Hi,
I am working through a huge list of incorrect duplicate values. To explain it further the list has some medication names and the corresponding unique alphanumeric code. I have to flag all the instances where the medication name is duplicated but the alphanumeric code is not same. The data would look something like this
Paracetamol A567
Medication2 A754
Medication3 A986
Paracetamol A567
Medication4 A876
Paracetamol A965
Medication5 A854
Now in the above example the second last entry should have been Paracetamol A567. I have been able to isolate the duplicate values using COUNTIF formula but could get my head around how to progress further to flag wrong entries.
Can anyone suggest. Thanks for your help.
coolcarnee
I am working through a huge list of incorrect duplicate values. To explain it further the list has some medication names and the corresponding unique alphanumeric code. I have to flag all the instances where the medication name is duplicated but the alphanumeric code is not same. The data would look something like this
Paracetamol A567
Medication2 A754
Medication3 A986
Paracetamol A567
Medication4 A876
Paracetamol A965
Medication5 A854
Now in the above example the second last entry should have been Paracetamol A567. I have been able to isolate the duplicate values using COUNTIF formula but could get my head around how to progress further to flag wrong entries.
Can anyone suggest. Thanks for your help.
coolcarnee