+ Reply to Thread
Results 1 to 2 of 2

Generating all possible combinations of 4 digit number via formula

  1. #1
    Registered User
    Join Date
    03-30-2021
    Location
    New providence bahamas
    MS-Off Ver
    Windows 10
    Posts
    1

    Generating all possible combinations of 4 digit number via formula

    I am seeking to generate all 24 and 60 combinations of a 4 & 5 digit numbers for a list of numbers in a single column in google sheets. Seeking some assistance? Thank you...
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Generating all possible combinations of 4 digit number via formula

    In case you want to joint all 4 & 5 digits into one row

    =JOIN(", ",A2:A5,B2:B5)

    ===> 2252, 5242, 2146, 2184, 12375, 85426, 52931, 84126

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 24 combinations for any 4 digit number
    By Ramya Sujesh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2020, 11:06 AM
  2. Use Excel to build 7 digit number combinations
    By Parka in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2019, 06:45 PM
  3. generating 6 number lotto combinations
    By Hollywood691 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2014, 02:04 AM
  4. Replies: 10
    Last Post: 01-24-2012, 08:58 PM
  5. Finding Combinations of a Three digit Number
    By darrylx in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-08-2011, 05:29 AM
  6. Replies: 2
    Last Post: 09-23-2010, 11:12 AM
  7. 5 digit number combinations
    By Puppiie in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 09-02-2010, 05:02 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