organize list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vindberg - 29 Mar 2008 03:46 GMT

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.

Reply to this Message

cht13er - 29 Mar 2008 04:13 GMT

> Hello,
>
[quoted text clipped - 22 lines]
>
> Thanks.

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

Reply to this Message

pub - 29 Mar 2008 06:00 GMT

vindberg <thvindberg@hotmail.com> wrote in news:ef753a9c-74f1-4656-971c-
1d4435e4c31e@13g2000hsb.googlegroups.com:

> Hello,
>
[quoted text clipped - 22 lines]
>
> Thanks.

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

Reply to this Message

pub - 29 Mar 2008 07:07 GMT

pub <puiblicstuff@home.com> wrote in news:f2kHj.78866$497.52207
@newsfe14.phx:

> vindberg <thvindberg@hotmail.com> wrote in news:ef753a9c-74f1-4656-971c-
> 1d4435e4c31e@13g2000hsb.googlegroups.com:
[quoted text clipped - 51 lines]
> did i get any of those assumptions wrong?
> let me know

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.

Reply to this Message

Rate this thread: