Extracting different combination to new worksheet

[marcmade]

Hi all,

I was wondering if there is any ways which I could do the following action using Excel function or vba

I have a number (eg. 1234) in a cell say B2 and I would like to check through a column (or table) to see if any combination (eg. 2341, 3421, 4321,1342...etc ) is present and extract it and place it on another worksheet

Example :
worksheet 1, Cell B2 is 1234

Check through a column ( or table ) on worksheet 1 with reference to B2
Then copy the different combination found on the column (or table) to worksheet 2

Thus worksheet 2 should have the following
1234, 2341, 3421, 4321, 1342 on different cells

Please advice. Thank You

[JOHN H. DAVIS]

If you only have 4 characters this may help.

Please Login or Register  to view this content.

[shg]

You could use a formula in a convenient column and filter on that:

	A	B	C
1		Input
2		1234
3	Number	Test
4	3124	TRUE	B4: =SUMPRODUCT(SMALL(--MID(A4, {1,2,3,4}, 1), {1,2,3,4}) * 10^{3,2,1,0}) = $B$2
5	3125	FALSE
6	2134	TRUE
7	1233	FALSE

The digits of B2 must be in ascending order.

[marcmade]

Thanks all for the respond.
By tweaking slightly... manage to get to code work as I wanted on my file.

[JOHN H. DAVIS]

You're welcome. Glad to help out.