View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kyoshirou kyoshirou is offline
external usenet poster
 
Posts: 133
Default concatenateRepeated

u guys know concatenate right.
For example:
A B C D
1 2 3 4
If concatenate, i got 1234.

what do i need to add in so that there will be no repeated same concatenate
(in order entry) values?
Example, users can have concatenate of 4321,1324,3241 BUT no 1234.

Thanks!