desk

Afternoon all, Looking for some help/advice please... I hope this makes sense. I have a holiday file which is set out in a similar manner as below and tracks the full year. The actual file has around 400 employees in it but for the sake of this I've just classes a few as different job types...

Trying to get an average from two disctinct arrays when two conditions exist For instance =IF(SUM(WP6:XY6,YD6:YL6)>0,AVERAGE(WP6:XY6,YD6:YL6),"") Which is fine, but I would like it to work when WP4:XY4 AND YD4:YL4 = to either CC or AB Can someone please help out?? I've been banging my head...

Hi I'm sure this is simpler than I'm finding. I have four columns of data which the number of rows vary from week to week. The data set is normally multiple days. Date | Name | Start | End The thing... I want to allocate each person a desk however I want it to check the end time of people...

Hello, I am looking to lock and protect the whole active sheet except for the whole column with a specific header "Desk", which is Column 3. <tbody> Date Desktop Desk </tbody> In my code, the unlock applies to Column 2 instead of Column 3 as that is the first found match to the...

Hi All have been trying to solve this one myself with a lot of googling, looking on forums etc and can't quite find an answer. I need to put together a rota for a small team operating audio-visual equipment. Some of the team are trained to operate the mixing desk plus microphones, some are...

Hello Experts, I need help for creating an Open aging incident report. I’m part of Service desk and my team lead has assigned me this task. I have pulled raw_data of incidents from ServiceNow a ticketing tool that we use. Below is how the raw data looks. Raw data generated on 4-Aug-2017...