Forum Discussion
Vlookup to find multiple variations of a text string
Did you compare your solution with my solution?
Your missing some shifts: DO, LMP1.
And your missing multiple names for the same shift on the same day.
And LMP produces false positives because of LMP1 and LMP2.
Detlef_Lewin PeterBartholomew1
Peter's solution looks good, I'll need to run it in the real schedule obviously to test it.
Not concerned if it doesnt pick up DO as those are days off which we don't need to display on sheet 2 (in Peter's solution I was intending to deselect DO and AL in the filter section of the pivot table using a macro) but would be concerned if it doesnt pick up duplicates at all.
My bad, the LMP should be LMP1 but we only use a number in shift codes if there are two people doing the same shift. In other words there is a CWE but will never be a CWE1 or CWE2. I think Ive just resolved the duplicate issue....the only duplicates we do use are the E and L shifts and we could possibly number them so no need to call them EO and LO.
Ill try the download myself but company admin privaledges may prevent me doing that, if so and I get someone in IT to look at it for me they may just come back and tell me it wont work!
Watch this space and thanks again for the help.