In col K I have list of locations. In column G, I have list of dates. If column D contains the words "Store-00989" and column G has the same date listed on another row, that shares the specific words in d, then in col E, I want to concat the data to show the location name in G and the words "Shift 1" (Example: Store-00989 Shift 1). If another row contains the same duplicate information, then I would like the words "Shift 1" to read "Shift 2" and so on. If there are no duplicates between D & G that do not meet this criteria, then the result should be location name listed in G.
I am not sure if it is possible to change the # after shift, but I need to make each of these duplicate shifts unique.
I am not sure if it is possible to change the # after shift, but I need to make each of these duplicate shifts unique.