Help with sort function

[Perebrine]

Hi,
Can someone please help it's driving me crazy.
I'm run a dart league which includes sorting averages & I'm trying to sort the averages on order. I paste a "Link" from another sheet & then copy values, but it doesn't come out as I'd like it.
I get the averages in the correct order but it leaves any blanks above the highest average.

[cbatrody]

Hi,

Can you post the sample template in excel format please? See the below URL for help on how to upload a file.

http://www.excelforum.com/members/da...ch-a-file.html

[Perebrine]

Here is the table I mean, I want the highest averages to be at the top, after sorting



Player Team 180 Played Won Ave D/Ave
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0
0 Bishop's Waltham 0 0 0 26 26
0 Bishop's Waltham 0 0 0 23 23
0 Bishop's Waltham 0 0 0 22 22
0 Bishop's Waltham 0 0 0 20 20

[Perebrine]

Hopefully attached is the file

[Perebrine]

Hopefully this is better (How can I delete the other thread?)

[hoyasaxa215]

Just enter a 0 in the blank cells and resort them.