Results 1 to 6 of 6

Drop duplicate values from string

Threaded View

sc0tt Drop duplicate values from... 06-13-2008, 10:03 PM
Ron Coderre Drop duplicate values from... 06-13-2008, 11:08 PM
sc0tt Very helpful; Can you show me... 06-14-2008, 08:15 PM
Ron Coderre Drop duplicate values from... 06-14-2008, 08:44 PM
jindon UDF, if you like... 1) hit... 06-14-2008, 09:10 PM
sc0tt wow 06-14-2008, 09:12 PM
  1. #1
    Registered User
    Join Date
    06-12-2008
    Posts
    14

    Exclamation Drop duplicate values from string

    I'm using this formulat to print out a string of numbers;


    here's the current formula: =SUBSTITUTE(TRIM(A1&" "&B1&" "&C1)," ","~")

    But I need to modify it so that it dumps duplicate values like; 4~4~6 ----> 4~6

    so if A1 and/or B2 and/or C1 are equal to one another; only one of the two or more duplicate values is displayed.

    Any thoughts?
    Last edited by sc0tt; 06-13-2008 at 10:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1