View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pumpkin Pumpkin is offline
external usenet poster
 
Posts: 13
Default count number of weeks missing for each individual in a database

Hi,

I need to measure attendace for the employees. I have a list of weeks worked
(eg. below) for each employee (numbered from 1-54) and I need to work out the
weeks that have not been worked and whether they are consecutive or not.

Please help :-)

bob jack
3 2
4 13
8 14
9 15
10 16
11 17