Removing Orders if any text in any row from one column matches the text in the order

Originally Posted by maxedison

I need a formula or macro to accomplish the following with two columns, call them column A and column C: Search column B. If the text in ANY cell in column C matches the text in a cell in column A, write the word "yes" in the cell in column C that is next to the match found in column A.

For example:

A B C
Dave Jessica
Dan Sarah
Jessica yes Mark
Kate
Mark yes
Sarah yes


And to be more specific, I'd want to match just the last 3 letters of the text in column C with the last few letters of text in column A.

Thanks!

Can you be more specific on that last point? What do you mean by 'the last few letters in column A'. How many is the 'last few'? Is this 3 as in column A?

Suppose you had two people called Paul and Saul for instance. Would you still wish to identify a match on the last three letters even though they're not the same person?

Rgds

Rgds,

I removed that last line in my post because I figured out a way around this issue that was causing me to want to flag orders that only matched the last few characters of text in a different column.

I'll spare you the details!

Originally Posted by maxedison

Rgds,

I removed that last line in my post because I figured out a way around this issue that was causing me to want to flag orders that only matched the last few characters of text in a different column.

I'll spare you the details!

OK, thanks

How about in B1 and copied down:

Please Login or Register  to view this content.

HTH

Awesome! That's just what I needed. Thanks!

Originally Posted by maxedison

Awesome! That's just what I needed. Thanks!

Ok Glad to help.

I realised immediately after I posted that it could be simplified by re-arranging and leaving out the NOT() function. i.e.

Please Login or Register  to view this content.

Regards