mercredi 21 février 2018

VBA Match Two Cells in Column to 2 Cells in corresponding column

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