Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
1,505
Views
Topic starter
Thanks team for sharing your ideas to solve the problems..
Now i came to seek the solution for a New topic...
How to find the weekly job order numbers based on the given weekend dates.....
Note: Its Better if you provide the solution for the Excel version of Office 2010....
| Update the weekly Number for the below table using data 1 tab... we need to find the no.of jobs done against the given weekend... | |
| Weekend | No.of Jobs |
| WE 19 July 2020 | |
| WE 26 July 2020 | |
| WE 2 Aug 2020 | |
| WE 9 Aug 2020 | |
| WE 6 Sep 2020 | |
| WE 14 june 2020 | |
| WE 21 June 2020 | |
Source data is:
| Job Name | Operator Name | Ignore Record | Flagged for QA | Start Date Time |
| Job Name-6333 | Operator 107 | N | N | 01-06-20 1:50 |
| Job Name-6334 | Operator 5 | N | N | 01-06-20 1:51 |
| Job Name-6335 | Operator 1 | N | Y | 01-06-20 1:52 |
| Job Name-6552 | Operator 97 | N | N | 01-08-20 6:11 |
| Job Name-6439 | Operator 106 | N | Y | 01-06-20 2:10 |
| Job Name-6336 | Operator 5 | N | Y | 01-08-20 6:11 |
| Job Name-6339 | Operator 65 | N | N | 01-06-20 1:56 |
| Job Name-6440 | Operator 1 | N | N | 01-06-20 1:58 |
| Job Name-6442 | Operator 26 | N | Y | 01-06-20 2:00 |
| Job Name-6441 | Operator 5 | N | Y | 01-07-20 6:11 |
| Job Name-6548 | Operator 58 | N | N | 01-06-20 2:07 |
| Job Name-6443 | Operator 32 | N | N | 01-07-20 6:11 |
| Job Name-6444 | Operator 53 | N | Y | 01-07-20 6:11 |
| Job Name-6337 | Operator 26 | N | Y | 01-08-20 6:11 |
Posted : 30/11/2022 3:01 am
Topic starter
Hi Arun,
Please start a new topic when you ask a new question. Please don't add a new question to the end of an already answered topic.
Please provide sample data in a file, rather than text/tables which we have to copy/paste/wrangle into a file. The easier you make it for us to help you the faster you'll get help.
Thanks
Phil
Posted : 30/11/2022 6:03 pm
