Previous Topic Next Topic

Need Excel Macro

Closed
Priya - May 22, 2011 at 12:46 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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.
Related:

1 response

Answer 1 / 1
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,166
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses