Hi there guys,

I am stuck with making the right formula for my situation. Let’s make though experiment that I have 1 TABLE that contains rows with 2 COLUMNS (or fields for every row).

COLUMN A

- includes numbers that can have duplicates for example: 1, 2, 3, 3, 4, 7, 7

COLUMN B

- has unique ID (also number) for example: 1, 2, 3, 4, 5, 6, 7

So the table would looks like like this:

1:1

2:2

3:3

3:4

4:5

7:6

7:7

And I need to make COLUMN C with formula that will rank COLUMN A by those conditions:

- Firstly, rank will be decided by number in this column A only (1 will be 1, 7 will be 7, but as you can see you can get two 7, or two 3),
- Then, duplicates will be decided by unique ID in COLUMN B.

So the result might look like this: (COLUMN A : COLUMN B: COLUMN C - RANK)

1:1:1

2:2:2

3:3:3

3:4:4

4:5:5

7:6:6

7:7:7

so the third number is actual rank.

HOPE, I EXPLAIN IT CORRECTLY, I AM NOT NATIVE ENGLISH SPEAKER.

If someone can help, this will save my life

Thank you