Results 1 to 10 of 11

Thread: Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-13-2014, 03:28 AM #5
    p45cal
    p45cal is offline
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    13
    See attached, an unmanageable and grotesque formula, but it seems to work. There must be a better way. Would a user defined function be acceptable (a macro)?
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Lookup Multiple Combination Of Values Across Columns To Find Corresponding A Value
    By nikhil83 in forum Excel Help
    Replies: 3
    Last Post: 07-29-2013, 09:15 AM
  2. Move data from rows into columns for every unique value
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-13-2013, 03:02 AM
  3. List Unique Values Using Formula
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 01-09-2012, 08:39 PM
  4. Generate A List of Unique Values / Unique Array
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 01-07-2012, 12:11 AM
  5. Lookup Multi-Column For Unique String Combination For Numeric Value Output
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-03-2011, 07:23 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