sort letters

thed9071

New member
Joined
Mar 7, 2014
Messages
4
Reaction score
0
Points
0
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))
 
It looks like it might be Swedish?

If so, translation should be:

=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))

yes, swedish and thanks for help but I got one problem with your code, maybe I dit something wrong. I use then

D1=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=T, I WANT D1=G

D2=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=T

Did you know what I did wrong?
 
yes, swedish and thanks for help but I got one problem with your code, maybe I dit something wrong. I use then

D1=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=T, I WANT D1=G

D2=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=T

Did you know what I did wrong?

I saw I write wrong in my answer I mean:


D1=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=G

D2=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=G, I WANT D2=T
 
It looks like it might be Swedish?

If so, translation should be:

=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))

I saw I write wrong in my answer I mean:

yes, swedish and thanks for help but I got one problem with your code, maybe I dit something wrong. I use then

D1=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=G

D2=INDEX($A$1:$A$2;PASSA(C1;$B$1:$B$2;0))=G, I WANT D2=T
 
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.
 
Back
Top