I hope someone can help me here, though I probably am not very good at explaining it.
I have a sheet with different types of working hours (D= dayshift, V=night shift, W=weekend shift)
I want a column (K) that automatically shows the person from row 2, that has either V or W on that particular day.
How do I do that?
TEST.xlsx
Bookmarks