Hello,
I have 10 products that have 3 columns of numbers assigned to them. What I want to do is to rank them by the first column and if the values are the same in the first column, then I would move to the second column for the tie breaker, and in the rare case that the values are the same in both the first and the second columns, then I would move to the third column. I attach below, where I hardcoded what the final rankings should be based on this example. I am looking for a formula for the final rankings column
I have 10 products that have 3 columns of numbers assigned to them. What I want to do is to rank them by the first column and if the values are the same in the first column, then I would move to the second column for the tie breaker, and in the rare case that the values are the same in both the first and the second columns, then I would move to the third column. I attach below, where I hardcoded what the final rankings should be based on this example. I am looking for a formula for the final rankings column
| Product Number | Attribute 1 | Attribute 2 | Attribute 3 | Ranking 1 | Ranking 2 | Ranking 3 | FINAL RANKING | |
1 | 30 | 3 | 5 | 8 | 7 | 2 | 8 | |
2 | 45 | 2 | 4 | 6 | 9 | 4 | 6 | |
3 | 23 | 4 | 3 | 9 | 5 | 7 | 9 | |
4 | 55 | 3 | 6 | 1 | 7 | 1 | 1 | |
5 | 50 | 6 | 2 | 2 | 3 | 8 | 4 | |
6 | 45 | 1 | 2 | 6 | 10 | 8 | 7 | |
7 | 50 | 7 | 4 | 2 | 1 | 4 | 2 | |
8 | 50 | 6 | 5 | 2 | 3 | 2 | 3 | |
9 | 12 | 4 | 1 | 10 | 5 | 10 | 10 | |
10 | 46 | 7 | 4 | 5 | 1 | 4 | 5 |
