Forum Discussion
Excel
Hi I have a Staff rota and I would like to create a list of staff availability based on date for staff who are not on shift or have booked holiday. I NEED TO SHOW STAFF WHERE CELLS IN COLUMN C a...
Column C is an overtime count in hours.....so it will increase as more overtime is done.
why this four person in this list?
| So for | |
| 02/01/2001 | |
| Person 6 | 0 |
| Person 8 | 0 |
| Person 10 | 12 |
| Person 7 | 24 |
Good point...there should only be 3 people in that list!
Person 10 should not be there!!
I'd input the date in B19 and the staff who have the lowest count from column C would appear when column D is blank and the corresponding column under the entered date is blank or contains H
I have been trying Index/Match/ aggregate......but I am having trouble with that approach.......