Hello all
I have 20 people all working different hours, i can work out what one
person is working on shift using
C5 07:30 D5 15:30
then having a range going down B46 07:30 all the way to B77 23:00
using =(IF(AND($C$5=$B46,$D$5=$B46),1,0))
This works for one person
how can i make this simple
that it is easy to understand the organization of the data in your
worksheets.
Regards,
Andy
On Fri, May 8, 2009 at 4:38 PM, Sabbycat dancoo...@googlemail.comwrote:
hi Aindril
as i am trying to calculate the lowest average sale week and the
average highest week
hi Aindril
as i am trying to calculate the lowest average sale week and the
average highest week, there is sporadical data in there, usually just
one to 2 weeks worth of sales that his rock bottom but these are not
at the beginning or the end of the year so in order for me to get this
info would
This is fairly simple question just dont know how to approach it
I have 52 columns of data i need to work out the average highest
number and the average lowest number
Any idea's
--~--~-~--~~~---~--~~