Hello all,

I am making a worksheet for staff members to track how they are
performing.

Column A contains timeslots in 15 mins intervals, Column B contains the
volume of transactions they should aim to complete by that timeslot.

Column E has the number 1-150 (transactions), then Column F is where
they will indicate they have completed a transaction (by typing a '1'
in the cell).

What I would like to do is use the worksheet to tell them if they are
on target.

I'm thinking it could work something like this -

When they indicate a transaction is complete, use a change event to
copy and paste NOW() value in adjacent cell (so that is does not
update).

Then lookup the timeslot in A:A that <= NOW(). Compare the total
transactions completed up until NOW() to the value in the list and then
be able to return a value (could be any value) based on whether the
number of transactions completed is or < what is in the list.

I'm not sure about the formula to do this - and was hoping someone
could help me out.

Thanks

Rob


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=495868