Concat Duplicate Data

[spyldbrat]

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.

 

[spyldbrat]

Kweaver - the formula only shows for 1 Store not the additional store that I added...but thank you for your help!!!!

 

[kweaver]

I guess I don't see what new store you added as there's no additional image.

 

[spyldbrat]

You could use an OR in your IF

=IF(OR(COUNTIFS(D:D,"Store-00989",G:G,G2)>1,COUNTIFS(D:D,"Loc-1971",G:G,G2)>1),D2&" Unarmed "&COUNTIFS(D$2:D2,D2,G$2:G2,G2),D2)

For some reason, when I apply your formula to the sample spreadsheet it works fine. When I change the words within the quotes to match up to my "real" data, it's applying Unarmed 1, 2 to every row in the column?

 

[spyldbrat]

I guess I don't see what new store you added as there's no additional image.

I am sorry Kweaver -- it was the little wrench that I threw in on #8

 

[mrshl9898]

Hard to say what the difference is...

Try ="Real Data"=D2 (or whatever cell has the data. If FALSE you may need TRIM
="Real Data"=TRIM(D2)

 

[spyldbrat]

Hard to say what the difference is...

Try ="Real Data"=D2 (or whatever cell has the data. If FALSE you may need TRIM
="Real Data"=TRIM(D2)

It's true

 

[spyldbrat]

This is what I have in my real data. Am I missing something?

=IF(OR(COUNTIFS(D:D,"BL-000154",G:G,G2)>1,COUNTIFS(D:D,"RA2709",G:G,G2)>1),D2&" Unarmed "&COUNTIFS(D$2:D2,D2,G$2:G2,G2),D2)

 

[mrshl9898]

It looks fine. How about comparing the BL-000154 and RA2709 cells, and the dates =CELL=CELL there must be something there not matching.

 

[spyldbrat]

What is confusing me is that every row in this column, even the ones that do apply to to what is in quotes in column D has unarmed 1, 2 etc after it?