excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
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)
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)