I need to make a decision based upon a bunch of values: My first excel sheet looks like this: Example:
Number Thing1 Thing2 Thing3 .... Thing7
1 0 1 0 1
2 1 1 0 0
I have another excel sheet that has the meanings associated with these values: Example:
Meaning Thing1 Thing2 Thing3 .... Thing7
Powerful 0 1 0 1
Medium 1 0 1 0
Low 1 1 0 0
Now I need to make a decision as to which number has what designation. The first sheet after processing should like this:
Number Thing1 Thing2 Thing3 .... Thing7 PowerLevel
1 0 1 0 1 Powerful
2 1 1 0 0 Low
Is this possible in excel ? If it is not then I am open to solutions from C# programming or any other language. Or maybe even an idea of how it can be done.
No comments:
Post a Comment