# Finding Sequence Within Data Set

1. ## Finding Sequence Within Data Set

Hi all,

I have an excel (attached. I think) which has monthly data of employees workdays with the following columns:
Name of an employee
Date of month
Day
Activity (workday/Non-Workday)

I need a formulae which will tell me if a person worked 6 days or more in one week (Sun-Sat).

thanks!

2. ## Re: Finding Sequence Within Data Set

I don't see where you have mocked up your expected results. What do you want to see? Where do you want to see it?

3. ## Re: Finding Sequence Within Data Set

Apologies
I would just expect to see it in a table format
Ive corrected the excel and reuploaded
i have no idea with how to go about it

4. ## Re: Finding Sequence Within Data Set

That's the same workbook with no changes. All I can see is one section highlighted in yellow in the source data - no expected results mocked up anywhere. Please try uploading the ammended workbook. Once we know what you are aiming for, we can help you to find a way to do it.

5. ## Re: Finding Sequence Within Data Set

Apologies
Now i've uploaded the correct file.
I highlighted those cells since it should return True.

6. ## Re: Finding Sequence Within Data Set

OK - right!

Having a look.

7. ## Re: Finding Sequence Within Data Set

Does a week start on a Sunday or a Monday? From your highlighting, I am gueesing the former, but you need to confirm.

8. ## Re: Finding Sequence Within Data Set

Weeks Starts on Sunday

9. ## Re: Finding Sequence Within Data Set

Thanks. I shall have a look.

10. ## Re: Finding Sequence Within Data Set

Here is a power query way of determining how many days were worked in a particular week

``Please Login or Register  to view this content.``
Excel 2016 (Windows) 64 bit
G
H
I
9
Name Week of Year Count
10
A
31
3
11
A
32
5
12
A
33
6
13
A
34
5
14
A
35
5
15
B
31
3
16
B
32
5
17
B
33
5
18
B
34
5
19
B
35
5
20
C
31
3
21
C
32
5
22
C
33
5
23
C
34
3
24
C
35
1
 Sheet: Current Month

11. ## Re: Finding Sequence Within Data Set

Here's a 365 option:

``Please Login or Register  to view this content.``

12. ## Re: Finding Sequence Within Data Set

And here's a slightly better version:

``Please Login or Register  to view this content.``

13. ## Re: Finding Sequence Within Data Set

And all in one:

``Please Login or Register  to view this content.``

14. ## Re: Finding Sequence Within Data Set

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

15. ## Re: Finding Sequence Within Data Set

seen, but not yet had a chance to delve into the excel...

16. ## Re: Finding Sequence Within Data Set

If it works, then the thread is solved, and should be marked as such. If you want an explanation of the formula, just ask.

17. ## Re: Finding Sequence Within Data Set

Once i see that it works ill mark it as solved...
thanks

18. ## Re: Finding Sequence Within Data Set

Here is another solution.

The whole table in one go:

``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)