Results 1 to 9 of 9

Unique list of paired combinations from a list

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2019
    Location
    Leeds, UK
    MS-Off Ver
    365
    Posts
    65

    Unique list of paired combinations from a list

    Hi all,

    i have a list of rail stations and I'd like a unique list of station pairs, excluding same-station pairs (eg. don't want Leeds-Leeds).
    I have the following formula which works but does include same-station pairs.

    =IF(ROW()-ROW($A$1)+1>COUNTA(Stations!$A$1:$A$4)*COUNTA(Stations!$A$1:$A$4),"",INDEX(Stations!$A$1:$A$4,INT((ROW()-ROW($A$1))/COUNTA(Stations!$A$1:$A$4)+1))&" - "&INDEX(Stations!$A$1:$A$4,MOD(ROW()-ROW($A$1),COUNTA(Stations!$A$1:$A$4))+1))
    Can anyone suggest a modification which would omit same-station pairs, please?

    Sample file provided.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List all unique 5 character combinations from a single column list of 28 characters
    By Book Guy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2023, 12:23 PM
  2. Make and regularly update a list of all combinations of two lists of unique values
    By Sherelle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2012, 07:21 PM
  3. Unique Combinations List
    By tonynap in forum Excel General
    Replies: 1
    Last Post: 10-17-2012, 04:00 AM
  4. List all combinations of 6/36 with unique 4 numbers
    By Martin888 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2012, 10:48 AM
  5. Replies: 7
    Last Post: 02-11-2011, 06:58 AM
  6. Finding paired items in a list.
    By gtckim in forum Excel General
    Replies: 3
    Last Post: 11-19-2010, 04:04 PM
  7. Consolidate five paired lists into one list
    By InfoSeeker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2008, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1