yeah, i used excel as well, i think the only thing wrong with my solution was the floor they were assigned too, just a matter of re-arranging them. glad it got solved for you.