Comparing values in a range

I have a file which has ten columns containing randomly generated numbers, and several thousand lines.

Each set of numbers, i.e one line, should be unique and the problem I have been having is to compare the numbers solely in VBA.

The solution I have at present is to concatenate the numbers and then to use the find function to determine if there are any duplicates.

I have attached a small sample and would be grateful if anyone has any ideas how it may be possible to achieve this.

Many thanks

Jeff

Thanks a lot for the advice, I will see how it all works out.

Regarding the dulication issue, the numbers are nax 2 digit so I think that this should not be an issue as they are sorted in ascending order.

Thanks again

Jeff