tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 375
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi all,
Hope you can help.
Below is an image of data the our work program produces but it doesn't really do what I need.
What I would like is as follows:
Step 1:
Copy the data into a new tab
Step 2:
Delete any rows that have dates/times in it that doesn't contain "Sickness Absence" in the Description (Col H)
I know some won't have sickness so there won't be any filled rows, but that's fine for the purpose I need.
Ultimately, I just need to see how many sickness days each person has, so if you have a better solution I'm all ears
Thank you
Thank you.
Hope you can help.
Below is an image of data the our work program produces but it doesn't really do what I need.
What I would like is as follows:
Step 1:
Copy the data into a new tab
Step 2:
Delete any rows that have dates/times in it that doesn't contain "Sickness Absence" in the Description (Col H)
I know some won't have sickness so there won't be any filled rows, but that's fine for the purpose I need.
Ultimately, I just need to see how many sickness days each person has, so if you have a better solution I'm all ears
Thank you
Thank you.