Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Help! (please)
I've looked at using INDEX & MATCH etc for these but can't quite get what I want. I have a list of staff's leave each month, set out as below. Members of staff do not always work the same number of hours, so a day off is denoted as their number of hours, so below this is 7.5. I need to have a function/formula that returns which days a person has had off. For example in the sample below I would like a result of "Mon 01 Feb 16, Wed 03 Feb 16, Tue 09 Feb 16." It wouldn't matter if these results were in individual cells as I could concatenate. As a refinement (and if I'm not asking too much) if someone has a half-day it's denoted as 3.75 - could we cater for that too? Col C Col D Row 1 Employee/Date Hours per days row 2 John Mills row 3 row 4 Mon 01 Feb 16 7.5 row 5 Tue 02 Feb 16 row 6 Wed 03 Feb 16 7.5 row 7 Thu 04 Feb 16 row 8 Fri 05 Feb 16 row 9 Sat 06 Feb 16 row 10 Sun 07 Feb 16 row 11 Mon 08 Feb 16 row 12 Tue 09 Feb 16 7.5 row 13 Wed 10 Feb 16 row 14 Thu 11 Feb 16 row 15 Fri 12 Feb 16 Thanks in advance! Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Annual Leave Summary | Excel Discussion (Misc queries) | |||
Annual leave | Excel Discussion (Misc queries) | |||
Annual Leave Planner | Excel Discussion (Misc queries) | |||
Annual Leave | Excel Discussion (Misc queries) | |||
Tracking annual leave | New Users to Excel |