keneastman
New Member
- Joined
- Apr 17, 2002
- Messages
- 1
I'm building a DB that will contain up to about 100 lists. Each list will contian up to 2000 numeric values (they will each be stored in a single column on the spreadsheet). I then want to be able to identify how many of the numbers in list 1 are also in list 2...or how many numbers in list 83 are also in list 21...etc. Ideally, I would be able to identify up to 10 lists and the "formula" would tell me how many matches there are across lists. The result table might look something like this...
List 1 2 3 4 5 6
1 100 41 2 76 ...
2 41 100 43 31 ...
3
4
5
6
The numbers in the grid represent the number of matches that intersect both lists.
Ideas????
Thanks.
This message was edited by keneastman on 2002-04-18 18:28
List 1 2 3 4 5 6
1 100 41 2 76 ...
2 41 100 43 31 ...
3
4
5
6
The numbers in the grid represent the number of matches that intersect both lists.
Ideas????
Thanks.
This message was edited by keneastman on 2002-04-18 18:28