Results 1 to 10 of 24

Thread: Flexible Concatenation Function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-31-2013, 05:46 AM #4
    nlk.public
    nlk.public is offline
    Junior Member
    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0

    Edit to make it remove duplicates?

    Rick, brilliant UDF. Could this be modified to exclude duplicate values? Let's say the range A1,B1,C1,D1 has values of ABC,DEF,ABC,123. The desired result of the modified concat UDF would be to display in one cell: ABC,DEF,123 (cutting out the second ABC).

    Doable???

    -N
    Last edited by Admin; 02-02-2013 at 09:11 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. FORMATTED Flexible Concatenation Function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 1
    Last Post: 10-14-2012, 03:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules