Get lower half of a column of numbers
Hello,
I'd like to pick out the lower half of a column of numbers, basically
anything <median(a2:a50). Is there a way to do this as a sort? I'd like to
remove the upper half. After that I'd like to sort on another field.
Thanks,
Ellen
|