Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-01-2022, 02:11 AM
Paulrwoolley Paulrwoolley is offline Permutations of a list of numbers Windows 10 Permutations of a list of numbers Office 2021
Novice
Permutations of a list of numbers
 
Join Date: Jul 2022
Posts: 8
Paulrwoolley is on a distinguished road
Default Permutations of a list of numbers

Hi

I am not very competent in Excel..

I have a list of numbers: 2 3 5 7 11 13 17 19 23 29 31 37 41
(i.e. the first 13 prime numbers).

I would like Excel to return a list showing all the (8000+) permutations of those numbers. Eg if it was just the numbers 1 2 3, Excel would return:

1 2 3
1 3 2
2 1 3
2 3 1
3 1 2


3 2 1

If a kind reader would be able to just send me a link to a file that has this done already, it would be greatly appreciated as I do not understand 'modules'!!

Many thanks!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Aligning numbers (to the right) in a numbered list OneNote45 PowerPoint 1 03-09-2021 07:51 AM
parsing numbers from a list JBF Excel 2 10-14-2018 12:33 PM
Permutations of a list of numbers Pasting With Original Numbers From List BarnabyS Word 15 08-16-2018 11:53 PM
Picking Highest numbers out of List JBF Excel 7 03-12-2018 01:14 AM
Permutations of a list of numbers How to add 10000 numbers in a list without dragging down Pleasehelpmewithexcel Excel 3 12-18-2015 06:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft