Hi,

Am Fri, 21 Mar 2014 01:33:19 +0000 schrieb sumesh56:

I have a sheet named SEATING PLAN which says who to sit in which exam
room.
I have another sheet named DISTRIBUTION which displays each class
division to diffeent exam roooms.

I don't see any matching data in your two sheets. Not even the class and
the classes do match.
Can you explain more or can you put the expected values into sheet
"DISTIBUTION" and upload that file?


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional