Need help with this rankings

[Jack Morn]

Lets say i have some rankings like this

Name | Points | Country | Points2

AAA | 100 | ZZZZ | 100
BBB | 90 | ZZZZ | 90
CCC | 80 | XXXX | 80
DDD | 70 | KKKK | 70
EEE | 60 | ZZZZ | 50
FFF | 50 | XXXX | 40
GGG | 40 | YYYY |

I want to create the fourth column (Points2) similar to Column 2
(points) but with the exception that it can only have 2 from each
country in the list.

In the example, Team EEE will not appear in Points2 since it is the
third team from that country.

I have tried with numerous If() functions variation with in addition to
Countif but can't seem to make it work.

 

[Anon]

Lets say i have some rankings like this

Name | Points | Country | Points2

AAA | 100 | ZZZZ | 100
BBB | 90 | ZZZZ | 90
CCC | 80 | XXXX | 80
DDD | 70 | KKKK | 70
EEE | 60 | ZZZZ | 50
FFF | 50 | XXXX | 40
GGG | 40 | YYYY |

I want to create the fourth column (Points2) similar to Column 2
(points) but with the exception that it can only have 2 from each
country in the list.

In the example, Team EEE will not appear in Points2 since it is the
third team from that country.

I have tried with numerous If() functions variation with in addition to
Countif but can't seem to make it work.

Assuming the data you give occupy A1:C7, put this formula in D1
=IF(COUNTIF($C$1:C1,C1)<3,B1,"")
and copy it down to D7.
Does this give what you need?

 

[Jack Morn]

Bah, i feel stupid seen it was so short.
Yes that worked almost to perfection, thank you very much. The only
thing is that when it skips an entry it leaves that cell in blank,
instead of the one that would come next.

It shows something like this using your formula.

Name | Points | Country | Points2

AAA | 100 | ZZZZ | 100
BBB | 90 | ZZZZ | 90
CCC | 80 | XXXX | 80
DDD | 70 | KKKK | 70
EEE | 60 | ZZZZ |
FFF | 50 | XXXX | 50
GGG | 40 | YYYY | 40

I would like it to show like this

Name | Points | Country | Points2

AAA | 100 | ZZZZ | 100
BBB | 90 | ZZZZ | 90
CCC | 80 | XXXX | 80
DDD | 70 | KKKK | 70
EEE | 60 | ZZZZ | 50
FFF | 50 | XXXX | 40
GGG | 40 | YYYY | 30

I cant do it like that but adding a fifth column with
=Large($O$1:$O$184,1) but will prefer it in the fourth column.
But thanks for the first formula, ill use that one if i cant get it to
work the way i want to.