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

Huawei MateBook X Pro (2019) review

Nvidia’s Gaugan tech turns simple colour blocks into realistic landscapes

New AirPods 2 launch: Release date, price, features & specs

AirPower : date de sortie, prix et fiche technique