RE: Is Multi-Sequence Search Selection Macro Possible?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It would be best to post some lines of the data so we can see the pattern.
there are many was of searching through data like this and things that you
may not think are important may require different programming techniques. I
have done thousand of programs like this and each one has some unique
requirements. it is better to see samples of the data than a description. A
picture is worth a thousand words.

"Cecil" wrote:

Hi:

This is the first time I am posting to this newsgroup and if it is not the
right place for my question, please point me to the correct newsgroup.

If I have three columns with a multiple sequences of numbers, separated by
empty cells,
is it programmatically possible to have a macro to select a specific pattern
in the three columns that meet the following conditions:

For example using columns R, S and T.

In column S, find a vertical sequence of 1, 2, 3, 4 and 5, that is followed
by a vertical sequence of

1 through 13, directly to the left of column S, the next row down in column
R, followed by a vertical

sequence of 1, 2, 3, directly to the right of column R, the next row down in
column S, and finally

followed by a vertical sequence of 1 through 19, directly to the right of
column S, the next row down

in column T?

My goal is to have a macro to find the right sequence of 40 numbers while
ignoring sequences that don't

match. A nice bonus would be if no matches are found after the search
completes, to display a "Match not found", messagebox!

Any help would be appreciated!
Thanks in advance,
Cecil



.

Relevant Pages

  • Re: an true information theory
    ... If a message has meaning then it has structure and will show a pattern. ... if there is a pattern in the sequence of numbers. ... solve the halting problem, which is uncomputable. ...
    (sci.math)
  • Re: For Sean Pitman: Review of "Meaningful Information"
    ... If the phenomenon in question shows a random-type pattern, ... have access to a code that contains a much longer sequence. ... Your model of single bit compression does not seem to me to be a ... strings with shorter input strings depends on the reference computer. ...
    (talk.origins)
  • Re: Panu Raatikainens review of two of Chaitins books.
    ... "AIT will lead to the major breakthrough of 21st century mathematics, ... which will be information-theoretic and complexity based characterizations ... because they don't discern a distinctive pattern or closest fitting analogy ... "Consider the problem of finding a rule for generating a sequence ...
    (comp.theory)
  • Re: Example of verilog-a serial bit source.
    ... sequence source suitable for transient simulation. ... The Pattern parameters specify the sequence of the four states. ... This is the bit string, which is a series of the four states, 1 0 m z. ... repeats from the specified bit to the end of the bit string. ...
    (comp.cad.cadence)
  • Re: Example of verilog-a serial bit source.
    ... sequence source suitable for transient simulation. ... The Pattern parameters specify the sequence of the four states. ... This is the bit string, which is a series of the four states, 1 0 m z. ... repeats from the specified bit to the end of the bit string. ...
    (comp.cad.cadence)