Looking to prevent duplicate text in cell

I'm very close. I know that I am very close. The VBA is way beyond my level of understanding - but I should be able to simply paste that into the bottom of my module right?

I've taken a look at your sample and I understand it - but when I try to import it into my example, every cell reads "#NAME?" - and of course I've altered the formula to fit my spreadsheet.

I know I am very close. For instance, Line 2 is the first line I enter formulas. Starting in column 'N' is my string concatenation. Columns O:X contain the values, which potentially duplicate (but I only look for values to match on a row by row basis). So normally column N would have been =O2&P2&Q2&R2&S2&T2...and so forth to X

I currently have this pasted through column N: =ConcatIf(O2:X2,"<>"&BB2,O2:X2," ",TRUE)

Also, if you don't mind can you explain the second parameter a little more. The whole "<>"&BB2 part. I'm trying to learn and not just copy. I am very grateful for the help and thank you for providing me with the information you have so far, and you probably don't remember me because I'm guessing you help a lot of people, but you have helped me a few times in the past. Thank you for sharing your knowledge.