Previous Topic Next Topic

Need Excel Macro

Closed
Report
-
Posts
47367
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 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

Answer 1 / 1
Posts
47367
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 11,263
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
Ask a question