Comparing groups of numbers for duplicates

[solnajeff]

HI

Happy New Year to everyone.

The problem I am trying to solve is as follows, I have groups of 20 numbers in columns, one per column and would like to compare the groups to determine if any group is duplicated on another line.

I had been looking at using VBA to copy the numbers to an array, sort from lowest to highest, concatenate and use that to compare each group. If possible however if there is a suitable formula it would be preferable.

I have attached a small sample to illustrate.

I would appreciate any comments you may have.

Regards

Jeff