I have a spreadsheet that lists names in the first column and then has columns to the right that say (for example) what work shift each person is on for that day. I'm looking for a formula that will look at one of the right hand columns for a specific shift (ie "LATE") and will then return all the names from the left column that correspond to that shift (hope this makes sense), this formula would then be applied to each column so that I end up with a list of names for each shift at the bottom of each days column.
How do I return these multiple results? All cells contain text only and are not alphabetical.
I've been looking for a solution for this for some time now, but none of the available options seems to work they either only work left to right (VLOOKUP), need to be alphabetical or require numerical data. I'm a total beginner when it comes to formulas so this is probably not helping...
Thanks
Bookmarks