Need Excel MacroClosed

Question

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.

Ambucias · Answer

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

Need Excel Macro

1 response

Similar discussions

Subscribe To Our Newsletter!