I'm trying to write code that will do the following. If there are two like values in column A then they should have the same values in the column B. If both columns match paste "match" in the column C, if they don't paste "wrong", if there aren't any that are the same in column A then paste "other".
Dog Bark Match
Cat Meow Wrong
Cow Moo Other
Dog Bark Match
Cat Ribbit Wrong
Any help would be much appreciated! I've only figured out how to do it using a loop with i + 1. Unfortunately this doesn't work when the values don't appear in the correct order. Thank you!
Aucun commentaire:
Enregistrer un commentaire