Results 1 to 4 of 4

Formula for 12345

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-15-2014
    Location
    Michigan, USA
    MS-Off Ver
    MS Office 2021
    Posts
    105

    Formula for 12345

    Is there a formula that would give me all the possible combination of 5 digits.
    In column A I have the Area A B C D E. Each area has a number in column B. Column D is not needed but it show the possible #. Column E-I shows the Digit position. And J shows the all the next to each other in one number (I have the formula worked out for J)
    Is there a way to auto figure all the possible number combinations without me sitting and type every possible combination hoping I got them all and didn't miss any.
    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. if a cell in column P contains "12345" then delete entire row
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2015, 10:55 AM
  2. How to enter "12345", where 12345 is from a cell, in Excel formula?
    By Ning in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-07-2013, 01:27 PM
  3. urgent! save excel to csv, 012345 will change to 12345!!
    By counterking in forum Excel General
    Replies: 1
    Last Post: 08-07-2012, 09:30 AM
  4. Change 12345 into 123,45
    By Washington in forum Excel General
    Replies: 3
    Last Post: 05-01-2007, 04:42 AM
  5. [SOLVED] import /paste -stop automatic conversion of text 05-12345 to date
    By artech in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 04:15 PM
  6. formating the number from 12345.1 to 12345.001
    By sr25 in forum Excel General
    Replies: 7
    Last Post: 11-29-2005, 11:55 AM
  7. [SOLVED] convert 12345(figure) into word
    By Hirak Chatterjee in forum Excel General
    Replies: 6
    Last Post: 11-06-2005, 03:00 PM

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