shamrock1118
New Member
- Joined
- May 4, 2017
- Messages
- 3
SO I have employee schedules sent to me like this:
<tbody>
</tbody>
And I'm getting them in by the hundreds and I would like to write a formula that reads it for me and tells me,
based on certain criteria, which arbitrary schedule number it is. (Schedule numbers were assigned randomly. They are just being used as a reference.) Each schedule number has a unique start time.
So this is the formula I have going on here for the above schedule:
=IF($C6=BV$4,IF($F6="",IF($G6="X",IF($H6="X",IF($I6="X",IF($J6="X",IF($K6="x",IF($L6="",BV$5,""),""),""),""),""),""),""),"")
<tbody>
</tbody><colgroup><col><col span="7"><col></colgroup>
C6 is the column with start time that was sent to me, BV$4 is the column containing the start time that matches the criteria of the schedule number in BV$5.
Now, for SOME UNGODLY REASON my formula works for MOST of the schedules EXCEPT for a select number of schedules. Schedule number 61 for example will not work. I don't understand.
PLEASE HELP.
Employee Name: | name | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |||
Start/End Time: | 8:30 AM | Week 1 | X | X | X | X | X |
<tbody>
</tbody>
And I'm getting them in by the hundreds and I would like to write a formula that reads it for me and tells me,
based on certain criteria, which arbitrary schedule number it is. (Schedule numbers were assigned randomly. They are just being used as a reference.) Each schedule number has a unique start time.
So this is the formula I have going on here for the above schedule:
=IF($C6=BV$4,IF($F6="",IF($G6="X",IF($H6="X",IF($I6="X",IF($J6="X",IF($K6="x",IF($L6="",BV$5,""),""),""),""),""),""),""),"")
BP | BQ | BR | BS | BT | BU | BV | BW | BX |
7:00 AM | 7:15 AM | 7:30 AM | 7:45 AM | 8:00 AM | 8:15 AM | 8:30 AM | 8:45 AM | 9:00 AM |
55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 |
<tbody>
</tbody><colgroup><col><col span="7"><col></colgroup>
C6 is the column with start time that was sent to me, BV$4 is the column containing the start time that matches the criteria of the schedule number in BV$5.
Now, for SOME UNGODLY REASON my formula works for MOST of the schedules EXCEPT for a select number of schedules. Schedule number 61 for example will not work. I don't understand.
PLEASE HELP.