Need Excel Macro [Closed]

Report
-
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
-
Hello,

I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cells P4 & P5 are same.

Example:
K4 K5 P

Row 1: TFPCYO317120 2816000006FS 50210450

Row 2: yyyyyy O317120 50210450

If P column are same values 50210450, then check TFPCYO317120 is partially match with any other cells like O317120 and return true.

1 reply

Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,517
Bare in mind that behind every answer, to help given on the forum, there are human volunteers who give their time trying to solve users' problems.

Therefore, it is expressly requested from kioskea forums users to show their utmost respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

* Please, re-write your message accordingly, respecting the politeness charter and repost your message.

Please, thank you, appreciate, greateful are words among those forms

We trust that you understand

Moderator

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!