what function in excell do i use to show lead postions in columns

[Guest]

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 it’s 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

 

[Cutter]

Try the RANK() function.

=RANK(A1,A1:C1) will give the ranking of the value in A1 as compared to
all the values in range A1 to C1