LinkBack URL
About LinkBacks
I would like to find matching pairs. If you have two tables - table1 with for sets of data (I, II, III, IV) with every data set containing five variables (Var1, Var2, Var3, Var4, Var5), and table2 with four sets of conditions (A, B, C, D) for every data set to match. Now, I want to make a macro to find a matching unique set of conditions in table2 for every unique set of data in table1, and this solution could be output in table3 (like for example: AIII, BI, CIV, DII).
Table2: set of conditions with its five variables:
A: 0; 4; Green; No; Number between 1 and 100
B: 1; 6; Red or Black; Yes; <90
C: 0; 8; White or Blue; No; >75
D: 1; 3; Red; Yes; Number between 50 and 79
Table1: set of data with its five variables:
I: 1; 6; Red; Yes; 77
II: 1; 3; Red; Yes; 55
III: 0; 4; Green; No; 65
IV: 0; 8; Blue; No; 80
The problem is solved only when pairs are formed for every set of data and every set of conditions. So, each set is used only once.
There could be more than one solution how to form pairs between the sets of data and sets of conditions. So more sulutions could be output in table4, table5, table6, and so forth.
Now for this to be useful to me I need to be able to extend this macro for using 150-200 sets of data and the same amount of conditions, and perhaps 20 variables for every set.
I would be very happy for some help here.
Register To Reply
Bookmarks