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
|