Hi Guys,

I really need your help.

I have a list of 50 component with their respective standard average deviance value.

My goal is,to form two groups from this set of data that posses an identical gaussian normal distribution.

i had already sort the deviance value in ascending order. It means the smallest value of deviance is at the top of my list and the biggest value is at the bottom of my list.

My methodology is:
1) to select two data respectively. it means the top one goes to Group A and 2nd Place goes to Group B. 3rd Place to Group A , 4th Place to Group B and so on..so at the end i have 2 group of data that have 25 Component each.

Is there any easy way to sort them according to my methodology in Excel? So i dont have to do them manually.

And, is my methodology OK to achieve my goal?

Thanks for your kind replies