Hello all!
I have a problem to solve.
I have 5 items: NE, NW, Central, SW and SE.
How do I list all 5 items without repetition in Excel without manual work? Thank you.
Hello all!
I have a problem to solve.
I have 5 items: NE, NW, Central, SW and SE.
How do I list all 5 items without repetition in Excel without manual work? Thank you.
Can you explain in more detail? It's not really clear what you're trying to do
Hello, Sorry I don't know where my previous thread reply went.
I have 5 items: NW NE CENTRAL SW SE.
I want to list them in ways without repetition: NW NE CENTRAL SW SE, NW NE CENTRAL SE SW, NW CENTRAL NE SE SW, etc.
Anyway to list them without manual work in excel? thank you.
And what about 9 items (city names) without manual label of hundreds of ways of having 9 cities listed without repetition? Thank you.
See attached
Input to the calculation is on Sheet1.
A1 is "C" for Combination, "P" for Permutation
A2 is number of items in the C/P
A3 down is list of items to be included
Click RUN button to trigger macro.
in B1
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",LEN($A1))),(COLUMNS($A:A)-1)*LEN($A1)+1,LEN($A1)))
Copy across to F then down
Hello John
It worked!
What about 9 locations, please see attached doc. Attachment 734430
Please see the attached document. Thank you.
Do you realise that there 362880 permutations?
Post #7 has instructions on how to use the macro.
Last edited by JohnTopley; 05-28-2021 at 02:43 AM.
Hello John,
yes, I do realize that is the number of permutations with 9 locations without repetitions. Thank you.
O.K then .
Post #7 has instructions on how to use the macro.
No:
Just change 5 to 9 in A2 ,add your list of cities in A3 down, then RUN
Thank you John!
The number of permutations have effective overwhelmed the Qualtrics drill-down question type. lol Thank you and have a wonderful weekend
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks