Scheduling with Excel Help

  • Thread starter Thread starter Trey
  • Start date Start date
T

Trey

I am in desperate need of help with scheduling large
amounts of employees.

I have a column used for scheduling employees to
districts. The districts are numbered, and I need to check
for duplicated assignments and ommitted assignments. How
can I do it?
Example:

Tom 30
Bill 31
Lori 32
Biff 34
Bob 34

I need to know that I left out 33 and duplicated 34. It
is a large schedule worksheet spanning Sun-Mon. Also,
what is the best way to build a preferred district matrix
where Excel will assign districts automatically?

I am a novice with excel. More capable than the average
user but no guru by any stretch of the imagination. I
know nothing about recording macro's etc.
 
Hi Trey,

You could use something simple like a COUNTIF. Suppose you
have an area in the worksheet that has all the disticts
listed. e.g.
Districts
1
2
3
...
50

Lets say this list starts in cell H2. The districts
assigned to the employees starts in cell B2. In cell I2
enter this formula:

=COUNTIF(B2:B55,H2)

Adjust ranges to suit and copy down as needed.

A result of 0 means that district was not assigned and a
result of >1 means that district was assigned multiple
times. BTW - I think Biff deserves a hefty raise!

As for your second question - ??? Don't really know what
you mean.

Biff
 
Thanks very much. Biff got a big raise. My schedule
works excellent. I am now trying to get it to assign
districts based on availability, seniority, and preference
of each employee. Thanks, Again. Trey
 
Back
Top