worker

Hello, Hope someone can help. I have a refreshable sheet named "Report" with data running from A6 down to A150. Months from April 2019 to March 2020 run across the page. This data in column A is in the format AREA1 Worker 1 Worker 2 AREA2 Worker 1 Worker 2 Worker 3 etc and it all finishes...

Hi everyone, I need to find out when was the last time a person did a task. It sounds easy but due to the way the data is displayed, I am unable to sort it out. Here you have an example of it: <tbody> Name 23/09 24/09 25/09 26/09 27/09 28/09 29/09 Worker 1 A B B A C D A Worker 2 B B C D...

Hi All, I am having two sheets , first sheet contains inventory details of batch number , second sheet contains worker list . I need to do condition formating to get the duplicate values . If the duplicate value found , need to copy paste a worker name to adjacent cell of the duplicate column...

Hi, Assuming these are 2 seperate lists in different tabs I would like to return the value in the second column as it is the closest match. Is this possible? If I wanted to return the first column i would use vlookup("*"&a1.... <tbody> Rehab Support Worker Support Worker Assistant...

I am trying to ascertain the last date that a worker provided their services for us. I have created some unique lookup values which include the worker's name, the department they worked in and if the job was 'filled'. The data I have has every single shift that the worker has ever completed for...

This is half of a formula I have..... =20-SUM(COUNTIFS('All Worker Time Off'!$C:$C,"john smith*",'All Worker Time Off'!$D:$D,”Time Off Request)) I need it to start at 20 and minus 1 for every time it finds, in the "All Worker Time Off" sheet, john smith in column $C:$C and also finds "Time...

So I have TAB 1 This contains a load of data broken down by worker. (I don't know how many lines each worker has) On Tab 2 I want it to pull that data through only for a certain few workers. What would be the best method of doing this?

Hello everyone, I would like to create a macro that copy my "worker" tab and pop a message box that will change the name of the new tab for example: "worker" >> "XXX" Also I want the macro to clear the contents of the cells I would allocate for my needs for example: A1 A2 A3 >>> Those are...

Hello everyone, I would like to create a macro that copy my "worker" tab and pop a message box that will change the name of the new tab for example: "worker" >> "XXX" Also I want the macro to clear the contents of the cells I would allocate for my needs for example: A1 A2 A3 >>> Those are...

Hi, Gents I am not professional in ms excel and So I'm sorry if my question is simple. I have 4 sheets witch their name is "M1" till "M4", and each worksheet contain a table, which the first column is worker name and others column is work days status But worker change in these 4 months and so...

Hello everyone, I would first like to thank you all for the help that I found on this forum, reading various threads as I was discovering Excel, working (and being stuck) on my project. Before we get to the good stuff, let me introduce myself and tell you why I am writing this post. My name...

I am trying to find how to return the workers pay the maximum number of weeks after their start date. As you can see in the example below, I have tried to OFFSET by the number of weeks (G2). However, this is returning the pay for worker Bob instead of the last instance of Paul (£25). I basically...

I currently have this in sheet1 columns A,B,C: Date Time Worker 04/04/2016 4,5 John 05/04/2016 2 John 06/04/2016 6,5 John 07/04/2016 0 -- 08/04/2016 0,5 Charles 08/04/2016 2 John 08/04/2016 0,5 William 09/04/2016 0 -- 10/04/2016 0 -- 11/04/2016 9 John 11/04/2016 3,75 William I...