Need Excel Macro

Closed
Priya - May 27, 2011 at 10:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 30, 2011 at 10:24 AM
Hello,

I am looking for 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.

Thanks in advance for your answer!
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 30, 2011 at 10:24 AM
Please add a sample workbook to some shared site and post back the link here
0