Hi,

Can anyone please help me?

I am writing a simple totalize program in Excell. Each month i will add
data to various columns. Each month these figures will change the positions
of each column. For example: the first moth column A may be 36, column B may
be 24 and column C may be 19; this will give a rank structure A = First, B =
Second and C= Third. The following month these numbers will increase because
of new data that will be added, however with this new data, Column A may now
be Second, C maybe first and B remain second. What I require is Function,
Marco €œwhat ever its called€�! that will be able to analyse the 3 figures and
in a cell below the figure insert the corresponding rank position, ie, First,
Second & Third and update them automatically each time new data is added and
the positions change.

Thank you

Ian Parry