View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SteveT
 
Posts: n/a
Default Concatenate Unique Entries

Ken,

your solution did the trick.

Thanks Kindly for the help

Best Regards, ST



"Ken Johnson" wrote:

Oops, call me a pillock!

Should've been...

Formula in H2 =COUNTIF($B2:B2,B2)

Formula in I2 =COUNTIF($B2:C2,C2)

Formula in J2 =COUNTIF($B2:D2,D2)

Formula in K2 =COUNTIF($B2:E2,E2)

Formula in L2 =COUNTIF($B2:F2,F2)

Formula in M2 =COUNTIF($B2:G2,G2)

That's what I get for taking shortcut.

Ken Johnson