Sorry, responded to the wrong post.
-----Original Message-----
I'm using XL2003 but I'm fairly confident that you can
do
it in XL2000. For step-by-step instructions, see:
http://www.contextures.com/xlcomments02.html#Picture
HTH
Jason
Atlanta, GA
-----Original Message-----
Hi!
Got a data manipulation challenge he
We've got a group of people, who through a completely
unrelated system have
been given numerical ranks or scores. I'm trying to
find a way to divide
these scores (people) into two teams with totals scores
(all the scores added
up) as even as possible.
For example:
Person One has a score of 5
Person Two: 4
Person Three: 2
Person Four: 5
I'm looking for some kind of function to take these 4
people (the real stuff
has a lot more people) and divide them into two teams
that have total scores
as close to even as possible.
Any ideas?
.
.