This is what I am currently using:
=SUMPRODUCT(--($E$2:$E$30000=$E2),--($F$2:$F$30000=$F2),--($O2<$O$2:$O$30000))+1
I am trying to rank store sales by style by units sold...this is working sort of...it won't break ties...I just want to get to my top 10 to 25
If any one can help...thank you in advance!!!
=SUMPRODUCT(--($E$2:$E$30000=$E2),--($F$2:$F$30000=$F2),--($O2<$O$2:$O$30000))+1
I am trying to rank store sales by style by units sold...this is working sort of...it won't break ties...I just want to get to my top 10 to 25
If any one can help...thank you in advance!!!