programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
Hey gang,
I'm creating a very basic ranking system that essentially ranks two columns separately (Column A and Column B), then adds the value of the two columns together in Column C. I then rank Column C but am getting duplicate values where the totals are the same (no issues with this so far). In comes the tiebreaker which essentially looks at a column of percentages in Column D which would use the highest percentage in Column D to break a tie of the total in Column C is the same.
I've used SUMPRODUCT in the past with success but in using it now, it's returning a 0 on every value and as a result, I'm still getting duplicate values. What gives?
Thoughts?
I'm creating a very basic ranking system that essentially ranks two columns separately (Column A and Column B), then adds the value of the two columns together in Column C. I then rank Column C but am getting duplicate values where the totals are the same (no issues with this so far). In comes the tiebreaker which essentially looks at a column of percentages in Column D which would use the highest percentage in Column D to break a tie of the total in Column C is the same.
I've used SUMPRODUCT in the past with success but in using it now, it's returning a 0 on every value and as a result, I'm still getting duplicate values. What gives?
Code:
=RANK($G5,$G$5:$G$20)+SUMPRODUCT(J$5:J$20=J5)
Thoughts?