Find Identical 4 numbers Straight Or Permuted In a Range

Hi,

Just to ask anyone down here could help with VB to create a VB so that i could put a list in column A and compare it with column C and i get result in column D if the numbers in column A and column C match in either straight or permuted way.

Thank you.Attached a sample of what i need.

Thank A Lot

Hi vanaj

Could you use a User Defined Function

Please Login or Register  to view this content.

vanaj,


Detach/open workbook Find4 arrays a c d InStr - vanaj - EF803173 - SDG16.xls and run macro Find4.



If you want to run the macro on another workbook:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Then run the Find4 macro.

Hi stanleydgromjr
if column 5 Trying to work out why its a match
2587 7984 =7984 is contained in: 7894
was vanaj intial data incorrect?

pike,

It would appear that his original result in cell D4 was not correct (not aligned):
4578 is contained in: 7894 (4578 is NOT contained in 7894)

@stanleydgromjr

;-)Thank you very much.

hi vanaj

if you would like a sub then

Please Login or Register  to view this content.

and please dont use the quotes to reply

Don't quote whole posts -- it's just clutter.

If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

vanaj,

You are very welcome.

Glad I could help.

Thanks for the feedback.

Come back anytime.