Good day
i am administering a competition in excel. the participants are split per region and each one has a sales figure and sales target. basically if you make your target, you get a prize.
however the salesman with the highest value above target per region will get ad additional prize if they won the initial prize.
What i have currently:
i am struggling to find a formula that only ranks the values displayed per region.
please help.
thanks
i am administering a competition in excel. the participants are split per region and each one has a sales figure and sales target. basically if you make your target, you get a prize.
however the salesman with the highest value above target per region will get ad additional prize if they won the initial prize.
What i have currently:
- i have identified all the initial prize winners based on the sales figure and target.
- in a new column i inserted an IF statement so that it shows the difference between sales figure and target only if the target was met.
i am struggling to find a formula that only ranks the values displayed per region.
please help.
thanks