masterexcelbundle
New Member
- Joined
- Feb 9, 2022
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hello,
This is probably very simple but I just can't figure it out!
Overall I want to know who supervising on the AM and PM shifts over the month by 5 consultants. I have filtered the data to the 'Available' status which is their Supervising status. I however don't want to include anyone who used it under 2hrs as they were probably just temping in and out.
So basically, I need to do a formula where is searches 5 separate columns for a matching date value, then from another 5 columns if duration is under 2hrs, and if other five columns match value "AM", then copy cell in column other columns.
I have uploaded 'DATA SETS1' as where the information is pulled from, using just 2 consultants but there are 3 others.
I have also uploaded 'DATA RESULTS' with the yellow cells how I am hoping the information to be pulled across as, either as AM or PM, also if the person is not listed on that date for the cell to show as blank. (e.g. if neither Adam or Chris worked on the 7th March, the cells under their names would be blank)
Thankyou in advance!
This is probably very simple but I just can't figure it out!
Overall I want to know who supervising on the AM and PM shifts over the month by 5 consultants. I have filtered the data to the 'Available' status which is their Supervising status. I however don't want to include anyone who used it under 2hrs as they were probably just temping in and out.
So basically, I need to do a formula where is searches 5 separate columns for a matching date value, then from another 5 columns if duration is under 2hrs, and if other five columns match value "AM", then copy cell in column other columns.
I have uploaded 'DATA SETS1' as where the information is pulled from, using just 2 consultants but there are 3 others.
I have also uploaded 'DATA RESULTS' with the yellow cells how I am hoping the information to be pulled across as, either as AM or PM, also if the person is not listed on that date for the cell to show as blank. (e.g. if neither Adam or Chris worked on the 7th March, the cells under their names would be blank)
Thankyou in advance!