cmanlongat
New Member
- Joined
- May 10, 2016
- Messages
- 21
http://i63.tinypic.com/2ugz67m.png
Main objective is to list Column A5 (Shifts) with either Day, Swing, or Grave depending on the employees schedule listen vertically in column C5:I5.
Is there a formula that could offer me with the right results? I tried an IF(ISNUMBER(SEARCH("1P - 9P",C5) "Swing", ""))) type of formula but I had to do this for every single shift time.
If anyone can help me with this, I would really appreciate it. Also, the schedule format has to be in that same way in the example, I cannot change it.
Main objective is to list Column A5 (Shifts) with either Day, Swing, or Grave depending on the employees schedule listen vertically in column C5:I5.
Is there a formula that could offer me with the right results? I tried an IF(ISNUMBER(SEARCH("1P - 9P",C5) "Swing", ""))) type of formula but I had to do this for every single shift time.
If anyone can help me with this, I would really appreciate it. Also, the schedule format has to be in that same way in the example, I cannot change it.
Last edited: