Hi,
I have two columns of data. One column lists a toy item and the next column lists whether it was made in Canada or not with a Y or N.
See below:
Toy CDN
plane N
bear Y
train Y
plane N
bear Y
bear Y
Is there a way that every time "bear" is entered, the CDN column automatically fills with "Y"?
Bookmarks