Previous Topic Next Topic

Need Excel Macro

Closed
Priya - May 22, 2011 at 12:46 AM
Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 - May 22, 2011 at 05:46 AM
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
Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,241
May 22, 2011 at 05:46 AM
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/apps-sites/internet-archeology/ccm/10131-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
0