Results 1 to 12 of 12

Make a unique list from all separated value across multiple cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    174

    Make a unique list from all separated value across multiple cells

    Apologies if this has been covered but I couldn't find anything.
    I also apologise that on this occasion I have not even been able to get started.


    I have a number of values in three columns that are separated consistently from each other.
    I need to somehow create a list of all the possible combinations taking a value from each cell.

    Is there a way of doing this with formulas or do I need to use VBA? Can it even be done with VBA?


    Sample attached.
    Attached Files Attached Files
    Last edited by Andrew-Mark; 09-26-2018 at 09:29 AM. Reason: Submitted too early

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. count unique comma separated names in range of cells
    By raogm2001 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-07-2017, 09:50 AM
  2. [SOLVED] Max of unique values in cells separated by a delimiter
    By sans in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-21-2013, 06:12 AM
  3. Replies: 1
    Last Post: 04-19-2013, 02:25 AM
  4. Creating a comma separated list for unique entires
    By kreativsoul in forum Excel General
    Replies: 9
    Last Post: 07-22-2012, 11:42 PM
  5. Replies: 8
    Last Post: 06-06-2012, 11:09 AM
  6. [SOLVED] Make unique list from a cells in one row
    By biber in forum Excel General
    Replies: 6
    Last Post: 04-07-2012, 03:43 PM
  7. How to make a list of words separated by commas?
    By Alle in forum Excel General
    Replies: 2
    Last Post: 08-28-2011, 05:39 AM

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