I have 4 columns in excell. ist & 3rd columns contain team numbers 1 through 18.
2nd & 4th columns contain scores. 2nd column are gross scores sorted with smallest number on top. 4th column are net scores sorted smallest number on top.
I want to create 4 more columns using that data,except only 9 rows in each column, starting with the lowest score of the gross column and team number, then the lowest score of the net colum and team number.as each score and team is posted the team and its other score is eliminated in the other two columns. When complete each team has been listed with either a gross or net score.
I can send a sample if that was confusing.
Enzio
2nd & 4th columns contain scores. 2nd column are gross scores sorted with smallest number on top. 4th column are net scores sorted smallest number on top.
I want to create 4 more columns using that data,except only 9 rows in each column, starting with the lowest score of the gross column and team number, then the lowest score of the net colum and team number.as each score and team is posted the team and its other score is eliminated in the other two columns. When complete each team has been listed with either a gross or net score.
I can send a sample if that was confusing.
Enzio
