Excel - Comparing Numbers

  Zak 21:44 09 Oct 2003

Column A has 10 different names and column B has respective totals for each name. These totals are obtained from other calculations and vary on a daily basis.
I would like Excel to automatically enter: 1st, 2nd 3rd etc in column C in the appropriate row.

Any ideas please?

  Zak 22:26 09 Oct 2003

Thank you all for your very quick replies. The spreadsheet works a treat.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Shadow of the Tomb Raider review

How designers created the world of smash hit drama Bodyguard

iPhone XS vs iPhone X: What is the difference?

Les meilleurs ordinateurs portables