Hi Stefi and thanks for the reply but after reading my message I think it is
not clear what I would like. I already have this but what I would like to do
is to have in another column a list of the names with the one with the most
points at the top and the points he has in the next column.
Can you help?
Soz
"Stefi" wrote:
Hi Soz,
column "A": names column "B": points
row 1:header
In cell C2 enter =IF(ISBLANK(B2);"";RANK(B2;$B:$B))
Fill down in column C until the expected maximum number of names, then sort
the table by column C! Re-sort the table after changes were made to it!
Regards,
Stefi
€žSoz€ť ezt Ă*rta:
Hello,
In column "A" I have peoples names and in column by I have their points.
It is possible for some people to have the same points. I would like to be
able to rank them and show their position in another column, ie. one with
most points top of the list and one with lowest points at the point. I have
tried a couple of formulae but without success, can someone help me? Do I
need a macro? Unfortunately not had any experiences with macros.
|