+ Reply to Thread
Results 1 to 3 of 3

Conditional addition - number intervals

  1. #1
    Registered User
    Join Date
    03-19-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    41

    Conditional addition - number intervals

    I have six columns and 15,625 rows. My data is working with combinations of 1 - 5.

    In column A, I want to sequence my input data as 1,2,3,4,5 and then 1,2,3,4,5 etc until row 15,625

    In column B, I want to sequence it as five 1s, then five 2s, then five 3s, then five 4s, then five 5s.

    In column C, I want to sequence it as 25 1s, then 25 2s, then 25 3s, then 25 4s, then 25 5s.

    In column D, I want to sequence it as 125 1s, then 125 2s, then 125 3s, then 125 4s, then 125 5s.

    In column E, I want to sequence it as 625 1s, then 625 2s, then 625 3s, then 625 4s, then 625 5s.

    In column F, I want to sequence it as 3,125 1s, then 3,125 2s, then 3,125 3s, then 3,125 4s, then 3,125 5s.

    This will create a permutations matrix of 15,625 outcomes of six questions with 5 answers each.


    Hope someone can help me! Tearing my hair out here!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Conditional addition - number intervals

    Assuming data start from A1:

    In A1:
    Please Login or Register  to view this content.
    In B1:
    Please Login or Register  to view this content.
    In C1:
    Please Login or Register  to view this content.
    In D1:
    Please Login or Register  to view this content.
    In E1:
    Please Login or Register  to view this content.
    In F1:
    Please Login or Register  to view this content.
    Drag all down
    Quang PT

  3. #3
    Registered User
    Join Date
    03-19-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Conditional addition - number intervals

    A perfect solution. Thank you enormously.

+ 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. Conditional Addition
    By cellfservices in forum Excel General
    Replies: 3
    Last Post: 01-16-2010, 01:17 AM
  2. Conditional addition
    By matralab in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2009, 09:47 AM
  3. Excel 2007 : Conditional Addition
    By hayhursm in forum Excel General
    Replies: 5
    Last Post: 10-15-2008, 09:40 AM
  4. conditional addition
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2005, 10:50 AM
  5. Conditional Addition
    By Andy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2005, 03:45 PM

Tags for this Thread

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