software

The first column in my range is a list of customers, columns 2-8 represent
days of week, headers Mon, Tue, Etc. In the days of the week portion of the
range we list a code that representing the Courier Co. that picks up the
order.

ie)
ABCDEFG
1CustomerMonTueWedThurFri Sat
2AAAFXFXUPS
3ABCFXBAXFX
4TTTFXUPS
5XYZFXFXFXI want to concatenate in column H all the Courier companies used to ship
orders out but eliminate the duplicates and put a comma in between ea unique
co.

Thanks for your help.
StevenHi Steven,
If nobodyelse comes up with a single column solution, and if columns H
to O are available you could have what you are after in column O then
just hide columns H to N this way..

Formula in H2gt; =COUNTIF($B2:B2,B2)

Formula in I2gt; =COUNTIF($B2:C2,C2)

Formula in J2gt; =COUNTIF($B2:C2,D2)

Formula in K2gt; =COUNTIF($B2:C2,E2)

Formula in L2gt; =COUNTIF($B2:C2,F2)

Formula in M2gt; =COUNTIF($B2:C2,G2)

Formula in N2gt; =IF(H2=1,B2amp;quot;,quot;,quot;quot;)
amp;IF(I2=1,C2amp;quot;,quot;,quot;quot;)amp;IF(J2=1,D2amp;quot;,quot;,quot;quot;)amp;IF(K2=1,E2amp; quot;,quot;,quot;quot;)amp;IF(L2=1,F2amp;quot;,quot;,quot;quot;)amp;IF(M2=1,G2amp;quot;,quot;,quot;quot;)

Formula in O2gt; =IF(RIGHT(N2,1)=quot;,quot;,LEFT(N2,LEN(N2)-1))

Fill all these formulas down to the bottom of your data then hide
columns H to N

Ken JohnsonOops, call me a pillock!

Should've been...

Formula in H2gt; =COUNTIF($B2:B2,B2)

Formula in I2gt; =COUNTIF($B2:C2,C2)

Formula in J2gt; =COUNTIF($B22,D2)

Formula in K2gt; =COUNTIF($B2:E2,E2)

Formula in L2gt; =COUNTIF($B2:F2,F2)

Formula in M2gt; =COUNTIF($B2:G2,G2)

That's what I get for taking shortcut.

Ken JohnsonKen,

your solution did the trick.

Thanks Kindly for the help

Best Regards, ST
quot;Ken Johnsonquot; wrote:

gt; Oops, call me a pillock!
gt;
gt; Should've been...
gt;
gt; Formula in H2gt; =COUNTIF($B2:B2,B2)
gt;
gt; Formula in I2gt; =COUNTIF($B2:C2,C2)
gt;
gt; Formula in J2gt; =COUNTIF($B22,D2)
gt;
gt; Formula in K2gt; =COUNTIF($B2:E2,E2)
gt;
gt; Formula in L2gt; =COUNTIF($B2:F2,F2)
gt;
gt; Formula in M2gt; =COUNTIF($B2:G2,G2)
gt;
gt; That's what I get for taking shortcut.
gt;
gt; Ken Johnson
gt;
gt;

You're welcome Steve.
Thanks for the feedback.

Ken Johnson