Hi All,
Could you please help me figuring out what and how to use a formula to find out how many continuous days agent has been working (monthly roster with split and any day Week Off)?
Attaching the problem sheet...Thanks
Sushil
Hi All,
Could you please help me figuring out what and how to use a formula to find out how many continuous days agent has been working (monthly roster with split and any day Week Off)?
Attaching the problem sheet...Thanks
Sushil
I could only do this using a user defined function. ie a Macro. or by inserting a helper row for each agent.
Cancel that:
This formula counts the consecutive days for row 4.
Entered using Ctrl Shift Enter
=MAX(FREQUENCY(IF(C4:BF4<>"OFF",COLUMN(C4:BF4)),IF(C4:BF4="OFF",COLUMN(C4:BF4))))/2
Last edited by mehmetcik; 01-16-2019 at 08:42 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks