Can u not just sort them?

--
HTH

Bob Phillips

"Soz" wrote in message
...
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.