a1 b1
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
Bookmarks