Macro or Formula needed to search data in cells

"hjopert@tinham.com" <hjopertham@yahoo.co.uk> wrote...
>I am looking for a way to create a formula/macro to do the following:
>
>My worksheet setup:
>
>A1:A30000 C1:C5000
>01 02 03 04 05 06 07 08 09 10 01 04 05 06 08 09 12 22 23 27
>02 03 04 05 06 07 08 09 10 11 01 03 05 06 07 08 09 14 22 32
>03 04 05 06 07 08 09 10 11 12
>04 05 06 07 08 09 10 11 12 13
>etc
>
>Each cell contains a 10 number sequence. The range A1:A30000 is my
>randomly generated sequence. And C1:5000 is my database of archived
>sequences.
....

Could any of these cells contain duplicate numbers, that is, multiple
instances of the same number?

Harlan Grove wrote:
<sniped>
>> Could any of these cells contain duplicate numbers, that is,
multiple
> instances of the same number?


Each cell contains a 10 number sequence, which does not contain
duplicates.

James.

Hello

No responses so far, so I will simplify my requirements.

The range A1:J30000 is my randomly generated number sequence. And
L1:U5000 is my database of archived sequences.

My worksheet setup:

A1:J30000 L1:U5000
01 02 03 04 05 06 07 08 09 10 01 04 05 06 08 09 12 22 23 27
02 03 04 05 06 07 08 09 10 11 01 03 05 06 07 08 09 14 22 32
03 04 05 06 07 08 09 10 11 12
04 05 06 07 08 09 10 11 12 13
etc

If I wish to check if A1:J=AD1 contains 7 or more of the numbers in
L1:U1. I use the formula:

=3DIF(OR((SUM(COUNTIF(L1:U1,A1:J=AD1))>=3D7)),"bad sequence","useful
sequence")

Ideally if the formula fails the 'logical test', I would like it to
continue testing the next row in the range ie L2:U2, L3:U3. If any row
causes A1:J1 to pass the 'logical test' the formula stops and returns
the result "bad sequence". If all rows in the range L1:U5000 are tested
and A1:J1 fails the test, then the formula returns the result "useful
sequence".

Is it possible that someone could provide a macro or UDF solution to
achieve the above so that after it's tested L1:U1 it automatically
loops through the other rows until it reaches L5000:U5000?

Please note I need to be able to adapt the range and 'logical test'.

Regards=20

James.