Repeating quads,triples etc

[JonathanLucky]

Dear Forum's Members, I have 10 columns of numbers that range between 1 through 80, as shown in example below.

Can anyone give me some tips on creating a VBA script that will scan rows of the data shown above and identify for me the rows where number triples, quads, etc (up to 10 numbers) repeat? I would like the script to seek out number matches that are in the any order.

For example

1 5 2 3 4 6 7 8 9 10

and

1 3 4 2 5 11 12 13 14 15

and

7 8 9 10 24 25 12 14 13 15 11

five numbers repeated - 1 2 3 4 5
five numbers repeated - 11 12 13 14 15
four numbers repeated - 7 8 9 10

Thanks!

[arlu1201]

Are the numbers in a row stored in one cell or in multiple cells?

Why do you have 2 lines for this - five numbers repeated - 1 2 3 4 5
five numbers repeated - 11 12 13 14 15

[JonathanLucky]

Thanks for your reply!

Are the numbers in a row stored in one cell or in multiple cells?

Yes. Each number in a row stored in one cell from B to K

Why do you have 2 lines for this - five numbers repeated - 1 2 3 4 5
five numbers repeated - 11 12 13 14 15

1 5 2 3 4 6 7 8 9 10
1 3 4 2 5 11 12 13 14 15
7 8 9 10 24 25 12 14 13 15 11

five numbers repeated - 1 2 3 4 5
five numbers repeated - 11 12 13 14 15
four numbers repeated - 7 8 9 10

And also

1 5 2 3 4 6 7 8 9 10
1 3 4 2 5 11 12 13 14 15
7 8 9 10 24 25 12 14 13 15 11

and so on

moreover there is a lot of triples and quads

so what I need is all possible repeated combinations from 3 to 10 numbers (if they exist)

above is just an example, I've a data with thousands rows of numbers

thanks!

[arlu1201]

Ok,

My question is cant five numbers repeated - 1 2 3 4 5
five numbers repeated - 11 12 13 14 15
be output as five numbers repeated - 1 2 3 4 5 11 12 13 14 15

[JonathanLucky]

I don't quite see what you mean. Could you clarify what you mean, please?

[arlu1201]

Oops sorry i confused myself.