Search for a string of numbers within an array

**Chubster** · 09-05-2014, 05:56 PM

Hi,
I'm looking for a way to search for a string of numbers within an array as best I can describe.
In example; I've go a search string of numbers (will always be 3 or 4 numbers in length) and want to perform a "find" on this search string (say 1-2-3-4) from a group of numbers that spans A1:D60.

The nuance is that the a match needs to occur if 3-1-2-4 or any variation of the search string is detected in the array.

The array number strings will also be 3 or 4 numbers in length.

ALL numbers must be present for a match; so a 4 number search string won't match to a 3 number array string and vice-versa.

Thank you and regards,
chubs.

**sktneer** · 09-06-2014, 12:23 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**mehmetcik** · 09-06-2014, 09:22 PM

You can use the match function in VBa

Please Login or Register  to view this content.

With regards your combinations you will have to use a series of loops.

Please Login or Register  to view this content.

The above macro created this table :

1234
1243
1342
1324
1423
1432
2341
2314
2413
2431
2134
2143
3412
3421
3124
3142
3241
3214
4123
4132
4231
4213
4312
4321

When I used the following code at the same position as you need to insert your match.

Please Login or Register  to view this content.

Search for a string of numbers within an array

LinkBack

Thread Tools

Rate This Thread

Display

Search for a string of numbers within an array

Re: Search for a string of numbers within an array

Re: Search for a string of numbers within an array

Thread Information

Users Browsing this Thread

Similar Threads

Search substring of an array matching a list of string from another array and returning as

Search for a string different sequences same numbers in array

[SOLVED] Test string search in an array

Search and replace(Regex) in string in array.

search for a part of string within an array of strings from another array list

Bookmarks

Bookmarks

Posting Permissions