combination function google sheet

[dabielcrbyton]

a1	b1	c1	d1	e1	f1	g1
4	5 7
6	7 10
8
9

i have google sheet



i have array of number from a3:a7
please i need function begin in b3
that can have any number, example (1 2 3 4 9 10)
that make 5 card Straight
i mean, which 2 cards
i need to get this
to have
5 card Straight
(each cell in column b can have maximum 2 cards )

as you see their are multi option to that
i need all those option

you can see in b3:
i only need one card (10)
to make 5 card Straight
with 6 7 8 9 (in a3:a7)


you can see in b3:
i need two card (5 7)
to make 5 card Straight
with 4 6 8 (in a3:a7)



you can see in b4:
i need two card (7 10)
to make 5 card Straight
with 6 8 9 (in a3:a7)


and each 5 card (in a3:a7)
have more option
i need all those combination
please



renumber please , that each cell in
column b can have maximum 2 cards

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: combination function in google sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[dabielcrbyton]

i am sorry
i will more careful next time
but i change the question so much
that it completely new question

 

[dabielcrbyton]

i post this early this week

old version of excel

a1 b1 2 2 4 4 4 4 5 5 7 8 7 8 i have an old version of excel something like 10 year ago i have array of number from a3:a10 please i need function begin in b3 that remove the empty cell in column a like you can see in column b thank you very very much

www.mrexcel.com

but i change the question completely

 

[Fluff]

I am not referring to your old thread on this site, I am referring to the thread I linked to.
Please take the time to read the rules, especially the link provided in rule#13

 

[dabielcrbyton]

but it different site
no ?
mrexcel and excelforum

there have different domain

 

[dabielcrbyton]

OK
i read now the rules


please
can you help me with my

combination function​

please

i will not post the same issue​

in mrexcel and also in excelforum
just in mrexcel

 

[dabielcrbyton]

i promise

 

[Fluff]

I cannot help, because
a) I don't understand what you are trying to do
b) I know very little about google sheets.

Please just be patient & hopefully someone else will help.

 

[dabielcrbyton]

someone else can help me
please