Hi guys.
I'm trying to write a little routine to scan a large set of data
looking for certain numerical events within a certain range.
What I'm trying to do, as a sample test, is find pairs of numbers
that show up consistnetly, as per example below.
I have a variable RANGE which deteremines how far back I want to
delve into the data set.
For example the RANGE = 10.
A B C
-----
1. 0 1 2
2. 3 1 2
3. 4 5 6
4. 2 1 9
5. 2 4 5
6. 6 2 1
7. 1 9 4
8. 4 4 5
9. 0 0 0
10. 7 2 1
And the ending Results should look something like this.
# times Pair
5 - 12
3 - 45
Any ideas on how to do this, or what method of statistics or name is
given to such a problem?
Thanks for any help.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/AccessVBACentral/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
