combinations generater?

[excelNewbie22]

hi!
i have 4 numbers in 4 cells:
a1=1 b1=2 c1=3 d1=4
(could be also 1-2-3-3)
how to generate all possible combinations of 4 numbers
out of 8 (1-2-3-4-5-6-7-8)
with repeats
and two out of the 4's (can be3's too)
need to be from the original range (a1:d1),
like 2-1-7-7 or 4,4,8,6 ?

very favorable by formula/s if possible

p.s
order not important (like 2-1-3-4 and also 3-2-1-4)

 

[Fluff]

Not pretty, with a formula

Fluff.xlsm
	A	B	C	D
1	3	4	7	3
2
3	1	1	3	3
4	1	1	3	4
5	1	1	3	7
6	1	1	4	3
7	1	1	4	7
8	1	1	7	3
9	1	1	7	4
10	1	2	3	3
11	1	2	3	4
12	1	2	3	7
13	1	2	4	3
14	1	2	4	7
15	1	2	7	3
16	1	2	7	4
17	1	3	1	3
18	1	3	1	4
19	1	3	1	7
20	1	3	2	3
21	1	3	2	4
22	1	3	2	7
23	1	3	3	1
24	1	3	3	2
25	1	3	3	3
26	1	3	3	4
27	1	3	3	5
28	1	3	3	6
29	1	3	3	7
30	1	3	3	8
Data

Cell Formulas
Range	Formula
A3:D1631	A3	=LET(s,BASE(SEQUENCE(8^4,,0),8,4)+"1111",m,--MID(s,{1,2,3,4},1),a,IFERROR(REPLACE(s,FIND(A1,s),1,""),s),b,IFERROR(REPLACE(a,FIND(B1,a),1,""),a),c,IFERROR(REPLACE(b,FIND(C1,b),1,""),b),d,IFERROR(REPLACE(c,FIND(D1,c),1,""),c),FILTER(m,LEN(d)<3))
Dynamic array formulas.

 

[excelNewbie22]

Not pretty, with a formula

why not pretty? it's works!!!

you should consider to make it possible to mark 2 maybe 3 answers as the right ones,
sorry i can't marks yours too!
Thanks Fluff !!

 

[Fluff]

Glad we could help & thanks for the feedback.

sorry i can't marks yours too!

You haven't marked anything as the solution.

 

[excelNewbie22]

lol.... i was sure i marked gordon's answer...

so now which one i'll marked?
the first correct one but not working for me
or
the later one but works for me

 

[Fluff]

If you are referring to the formula in post#9 that didn't work.

 

[excelNewbie22]

and the one in post#8?

 

[Fluff]

Nor did that one.
I think the only two that worked are post#16 & post#21

 

[excelNewbie22]

although #16 works, i'm more comfortable with all in one formula
thank you!

 

[Fluff]

Thanks for letting us know.