I have a Excel spread sheet of emplyees sales. For this example lets say that
cells A1 to A10 have emplyoee sales for the month. I need to calculate their
commissions but the commissions are based on the emplyee sales ranking. The
top seller gets 2% 2nd place gets 1% 3rd place gets 0.5% and the rest get
..25%. How can I have Excel calculate the biggest number then the 2nd biggest
then the 3rd biggest etc... Thank you!!