• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to permutate a list

Munich1970

New Member
Hi,

I have a list of 100 cities in an Excel sheet like

Dallas
Fort Worth
Austin
El Paso

I want to display the flight hours from each of these cities to the other like

Dallas to Fort Worth
Dallas to Fort Worth
Dallas to Austin
Dallas to El Paso

Fort Worth to Dallas
Fort Worth to Austin
Fort Worth to El Paso
Fort Worth to El Paso

In that order.

The problem is, there are hundreds of cities so its quite laborious to manually permutate this way.

My question:

Can Excel perform this permutation for me automatically?

or Is there a tool like

https://textmechanic.com/text-tools/combination-permutation-tools/permutation-generator/

which generates the permutation for me?
This tool is similar to the effect I want but it accepts only a few entries.

I have attached an Excel sheet to illustrate the problem.

Thank you.
 

Attachments

Back
Top