I am not sure what language version you are using.
In English Excel, it would be:
=INDEX($A$1:$A$2;MATCH(C1;$B$1:$B$2;0))
copied down
Hello
Hope someone can help me with the following problem.
Let say in column A we have different letters, column B have different numbers, the letters in column A are associated with the numbers in column B, A1->B1, A2->B2. I want in column C sort the numers from column B, smallest to largest and in column D I want to sort the letters. So if B2 smallest, C1=B2 and then A2=D1.
This is how it looks in excel.
...A....B...C...D
1T.....2....1...G
2G....1....2...T
A1=T, A2=G, B1=2, B2=1
C1: =MINSTA($B$1:$B$2;1) =>C1=1
C2: =MINSTA($B$1:$B$2;2) =>C2=2
So what formula should I write in D1 and D2 to sort column A in column D efter the sort resalt by column B in column C?. The result should give D1=G, D2=T in my example
I am not sure what language version you are using.
In English Excel, it would be:
=INDEX($A$1:$A$2;MATCH(C1;$B$1:$B$2;0))
copied down
It looks like it might be Swedish?
If so, translation should be:
=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))
After you enter: =INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0)) in D1, you need to copy down the formula to D2. The C1 should change to C2.
To copy down the formula, select cell D1, click and hold the little black box at the bottom right corner of the cell and drag down to D2, then let go.
Bookmarks