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
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!
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:
- Need Excel Macro
- Excel mod apk for pc - Download - Spreadsheets
- Spell number in excel without macro - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
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
May 30, 2011 at 10:24 AM
Please add a sample workbook to some shared site and post back the link here