I have a ranking for all of our sales reps - based on % of sales for Units (Col Y) with ties broken by Col AA
example :
rep 1 has 100% in Column Y and 15% in column AA
rep 2 has 100% in Column Y and 50% in column AA
rep 2 should be ranked higher

=IF(Y3<>"",RANK(Y3,Y$3:Y$42)+SUMPRODUCT((Y$3:Y$42=Y3)*(AA$3:AA$42>AA3)),"")
Problem - there are some that have 0's in both columns creating a tie..
How can I add column B (hire date) so that those hired recently are ranked higher in this tie.