Highest And Lowest Score Order

**StickCity** · 11-11-2014, 08:29 PM

Hi,

Can anyone help with this highest and lowest score order. As I just can't get them in the order that I want. The formulas that I'm using just don't work, when there is duplicated numbers.

this is the order I want
Highest Score Name Week Name Week
1 22 Mick Week 12 Mick Week 12
2 21 Albert Week 13 Albert Week 13
3 20 Steve Week 12 John Week 8
4 20 John Week 9 Bish Week 9
5 20 Bish Week 8 Steve week 12
6 19 Albert Week 13 Ablert Week 10
7 19 Mick Week 12 Bish Week 12
8 19 Bish Week 10 Mick Week 13
9 18 Bish Week 10 Bish Week 8
10 18 Bish Week 8 Bish Week 10

Sorry if this is not very clear!

Please see the attached file

Highest and Lowest Score Order.xlsx

**karedog** · 11-12-2014, 04:15 AM

Hi,

The quickest way is to transpose the data, since Excel's priority is to process row by row.

But if you still want to keep your data that way, then these are the array formulas :

I8 :

Please Login or Register  to view this content.

H8 :

Please Login or Register  to view this content.

)

S8 :

Please Login or Register  to view this content.

R8 :

Please Login or Register  to view this content.

Regards

**samba_ravi** · 11-12-2014, 05:52 AM

see the attached file

**StickCity** · 11-12-2014, 07:49 AM

Thank you karedog and nflsales, they both work! I will be looking at both to see how they work as I'm still learning excel and I may come back to you both with questions at a later date. Since I have started this work sheet I have learned a lot and that the data should have been row by row. I'm marking this as solve and giving you both some reputation as a thank you for replying so quickly.