MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Hi all,
Is anybody able to help me with a little excel problem? I've added an example of some data below that I need to sort. Basically I need to select the lowest 50% of the list and put this into one table with the highest 50% being sorted into another table. The list varies in size so I'm unable to use the large/rank function. I'm hoping it's pretty straight forward but I'm not sure which function to use.
Many thanks in advance.
Ben 18.15
dave 18.27
karl 18.34
sam 18.42
angela 18.56
steve 18.62
luke 19.23
brad 18.21
john 18.62
joe 18.63
isla 18.64
chris 18.25
richard 18.53
vicky 18.52
lianne 18.54
nat 18.58
Use RANK() / COUNT() and results <0.5 are upper half, >0.5 are lower half. Give responses a value of 0 or 1 to make extraction easier.
Cheers stoner, I'll give that a go later.
Thanks.