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