Hello,

I have a long list of names in column A, and in Column B next to each name is one of 10 group identifiers (Advertising, Marketing, Finance, etc). I'd like to divide the 300 names into groups of four people, with none of the four people having the same group identifiers. So, groups of four people that look like:
Column A Column B
Amanda Jones Marketing
Shelly Stevens Finance
John Banana Advertising
Tim Stewart Logistics

What is the best way to do this?

Thanks,
smalls