organize list

  • Thread starter Thread starter vindberg
  • Start date Start date
V

vindberg

Hello,

I have a problem, and i hope you can help me!

I got a list of a private football contest. It look like this:

A B
1 Sara 12
2 Morton 8
3 Hans 10

and so on...

I want to organize them automatic, so Morton will come first, Hans
number two and Sara last...

The numers and names comes from other cells, ex( A1= D2) and
( B1=D7).The numbers in the B cells, changes all the time, when we get
new results, thats why the table has to change.

How do i code them, so the name and numers changes places, and the
highest number ( with name) is at the top?

I really hope you can help!

Thanks.
 
Hello,

I have a problem, and i hope you can help me!

I got a list of a private football contest. It look like this:

A B
1 Sara 12
2 Morton 8
3 Hans 10

and so on...

I want to organize them automatic, so Morton will come first, Hans
number two and Sara last...

The numers and names comes from other cells, ex( A1= D2) and
( B1=D7).The numbers in the B cells, changes all the time, when we get
new results, thats why the table has to change.

How do i code them, so the name and numers changes places, and the
highest number ( with name) is at the top?

I really hope you can help!

Thanks.
Click to expand...

If you go into the cells A1, B1, C1, etc that are linked to other
cells and press F4 so that it looks like =$D$1 etc. you will be able
to sort without messing up the references.

HTH

Chris
 
Hello,

I have a problem, and i hope you can help me!

I got a list of a private football contest. It look like this:

A B
1 Sara 12
2 Morton 8
3 Hans 10

and so on...

I want to organize them automatic, so Morton will come first, Hans
number two and Sara last...

The numers and names comes from other cells, ex( A1= D2) and
( B1=D7).The numbers in the B cells, changes all the time, when we get
new results, thats why the table has to change.

How do i code them, so the name and numers changes places, and the
highest number ( with name) is at the top?

I really hope you can help!

Thanks.
Click to expand...


a couple of questions just to clarify
Morton has 8 and is 1st, but then you say you want the highest number at
the top.
so you want to see
Sara 12 thats 3rd place in the 1st row
Hans 10 2nd place in 2nd row
Morton 8 1st place in 3rd row

am i reading that right?

also
A1=D2 and D2=Sara
B1=D7 and D7=12

is
A2=E2 and E2=Hans
B2=E7 and E7=10

A3=F2 and F2=Morton
B3=F7 and F7=10

and the scores in row 7 will change?

did i get any of those assumptions wrong?
let me know
 
a couple of questions just to clarify
Morton has 8 and is 1st, but then you say you want the highest number at
the top.
so you want to see
Sara 12 thats 3rd place in the 1st row
Hans 10 2nd place in 2nd row
Morton 8 1st place in 3rd row

am i reading that right?

also
A1=D2 and D2=Sara
B1=D7 and D7=12

is
A2=E2 and E2=Hans
B2=E7 and E7=10

A3=F2 and F2=Morton
B3=F7 and F7=10

and the scores in row 7 will change?

did i get any of those assumptions wrong?
let me know
Click to expand...

i hope thats the case

try this

A1
=INDEX($D$2:$F$7,1,MATCH(MAX($D$7:$F$7),$D$7:$F$7,0))

B1
=INDEX($D$2:$F$7,6,MATCH(MAX($D$7:$F$7),$D$7:$F$7,0))

A2
=INDEX($D$2:$F$7,1,MATCH(MEDIAN($D$7:$F$7),$D$7:$F$7,0))

B2
=INDEX($D$2:$F$7,6,MATCH(MEDIAN($D$7:$F$7),$D$7:$F$7,0))

A3
=INDEX($D$2:$F$7,1,MATCH(MIN($D$7:$F$7),$D$7:$F$7,0))

B3
=INDEX($D$2:$F$7,6,MATCH(MIN($D$7:$F$7),$D$7:$F$7,0))

i just used index() and match() with max() median() and min()
if you have more people then you might want to add rank() to your formula
and your data, then just do a hlookup() or index/match off the rank()

hope that worked, or at least gave you some ideas.
 
Back
Top