LinkBack URL
About LinkBacks
heloo. first thanks for sharing your vast ray of knowledge.
problem
i want to count the number of shifts an employee works in a row. if employee has a day off the number resets to zero. the maximun number of shifts in a row is ten
heloo. first thanks for sharing your vast ray of knowledge.
problem
i want to count the number of shifts an employee works in a row. if employee has a day off the number resets to zero. the maximun number of shifts in a row is ten
What would you expect from this:
Y Y Y Y N N Y Y Y Y Y Y N N N Y Y Y Y N N Y
Where N is Off and Y is working day
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
a progressive count but when n appears, count restarts
So the answer is 1?
i was thinking of adding another row of cells underthis to show how the count was progressing. my problem is how do i say n resets the count.
Specify the outcome then we can think on solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks