Is there a way to match patterns of characteristics of data? Assume I have 10,000 rows of data and each is made up for 5 columns. The first column is a unique customer number and the remaining four columns each have either a 1 or 0. There are 15 unique patterns of 1 or 0 in the data set (e.g. 1,1,1,1 or 1,1,0,1, or 1,0,1,1 or 0,1,0,0 etc...). For each row of data I am trying to match its pattern against the 15 possible combinations and determine which combination it is? Any suggestions?
<tbody>
</tbody>
DATA | Possible | Outcomes | ||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Formula? | Year 1 | Year 2 | Year 3 | Year 4 | ||||
Customer | 1 | 1 | 1 | 1 | 1 | A | A | 1 | 1 | 1 | 1 | |
Customer | 2 | 1 | 0 | 1 | 1 | E | B | 1 | 1 | 1 | 0 | |
Customer | 3 | 1 | 1 | 1 | 1 | C | 1 | 1 | 0 | 1 | ||
Customer | 4 | 1 | 1 | 1 | 1 | D | 1 | 1 | 0 | 0 | ||
Customer | 5 | 1 | 0 | 1 | 1 | E | 1 | 0 | 1 | 1 | ||
Customer | 6 | 1 | 0 | 1 | 0 | F | 1 | 0 | 1 | 0 | ||
Customer | 7 | 1 | 0 | 0 | 1 | G | 1 | 0 | 0 | 1 | ||
Customer | 8 | 1 | 0 | 1 | 0 | H | 1 | 0 | 0 | 0 | ||
Customer | 9 | 1 | 0 | 1 | 0 | I | 0 | 1 | 1 | 1 | ||
Customer | 10 | 1 | 0 | 0 | 0 | J | 0 | 1 | 1 | 0 | ||
Customer | 11 | 0 | 1 | 1 | 1 | K | 0 | 1 | 0 | 1 | ||
Customer | 12 | 0 | 1 | 1 | 0 | L | 0 | 1 | 0 | 0 | ||
Customer | 13 | 0 | 1 | 0 | 1 | M | 0 | 0 | 1 | 1 | ||
Customer | 14 | 0 | 1 | 0 | 1 | N | 0 | 0 | 1 | 0 | ||
Customer | 15 | 0 | 0 | 1 | 1 | O | 0 | 0 | 0 | 1 | ||
Customer | 16 | 0 | 0 | 1 | 0 | |||||||
Customer | 17 | 0 | 0 | 0 | 1 |
<tbody>
</tbody>