Comparison

Dear All,

I have an excel sheet which looks like following,

Part assembly AVG
7 1.34 40.97
4 5.59 47.38
2 6.19 33.74
1 6.24 39.58
8 6.63 78.76
6 7.76 2.08
5 8.01 5.36
3 9.70 20.01

Now what i would want is following, 1st column says part which is number of parts of some machines(not sorted) , This data is collected manually from somewhere. what i want is, suppose i have 100 parts(1 to 100) and each part has Assebly and AVG column as output. now i want to compare value of assembly with AVG (here the requirement is - if assembly is smaller than AVG than put the part at the beginning(whole row) or if the assembly is grater than AVG put the part at the end. ( may be you can give me some macro coding for that) , that out put would look like following,

SL# Part assembly AVG
1 7 1.34 40.97
2 4 5.59 47.38
3 2 6.19 33.74
4 1 6.24 39.58
5 8 6.63 78.76
6 3 9.70 20.01
7 5 8.01 5.36
8 6 7.76 2.08

please provide me some solution for the above post

thanks

Kanti