Given the following with expected results: Point Pm10 Rank 1 .12 2 2 .13 1 3 .12 3 4 .12 4 1 .12 3 2 .15 1 3 .13 2 4 .11 4

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Rank If 1 condition unique rank

Thread starter cyrilbrd
Start date May 15, 2019
Tags

expected pm10 point rank results

cyrilbrd

Well-known Member

May 15, 2019

Given the following with expected results:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Point[/TD]
[TD]Pm10[/TD]
[TD]Rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].12
[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD].13[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD].12[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD].12[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].12[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD].15[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD].13[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD].11[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]