Question #14618132

Excel - Combinations from data set?

How can you determine all of the possible combinations for a series of 1000 numbers. For example, I am trying to determine all of the possible combination for all of the 3 digit zip codes in the United States for a project. I think the best way to do this is use the Kutool download for Excel but I'm open to other suggestions. Then once I have the answer with all of the combinations I want to display all of the possible combinations in two columns next to one another. I'm thinking this will be 1,000,000 combinations so doing it by hand will take forever. Does anyone know how to do this?

2016-10-27 04:59:56

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The helpinganswers.com is a free-to-use knowledgebase.
  The helpinganswers.com was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters

  Contact: support@helpinganswers.com

C'mon... follow us!

Made by, history, ect.