View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul
 
Posts: n/a
Default Finding the Last Working Day

so we only have to count three a's(to begin with),or do you need to know if
there were more than three?
--
paul

remove nospam for email addy!



"junoon" wrote:

Since its possible that there could be 3 A's in the beginning of the
month for some employees who were absent for 3 consecutive days but
later on rejoined the company ( were accepted by the company), i want
to find the latest 3 A's i.e..... 3 consecutive A's later in the month
& get a LWD just before them.


PLEASE HELP ASAP