Assuming col1 = A, col2=B, col3=C...Then you would put this in the 4th column and copy/paste down.
=OR(A1=B1,A1=C1)
adjust to fit your ranges
Assuming col1 = A, col2=B, col3=C...Then you would put this in the 4th column and copy/paste down.
=OR(A1=B1,A1=C1)
adjust to fit your ranges
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks