Results 1 to 3 of 3

Repeating Groups of Numbers

Threaded View

stevejay6 Repeating Groups of Numbers 09-17-2015, 12:31 PM
Paul Re: Repeating Groups of... 09-17-2015, 12:51 PM
newdoverman Re: Repeating Groups of... 09-17-2015, 03:27 PM
  1. 09-17-2015, 12:31 PM #1
    stevejay6 is offline
    Registered User
    Join Date
    09-17-2015
    Location
    Uganda
    MS-Off Ver
    2013
    Posts
    1

    Repeating Groups of Numbers

    Hi,

    I'm trying to fill Column A with the following series: A1=1, A2=1, A3=1, A4=1, A5=2, A6=2, A7=2, A8=2, A9=2, etc. In short 3 1's, 3 2's, 3 3's up to 15360. AutoFill will not work for me for this. Is there a better way?? Thanks in Advance!!!

    This is related to chris's question in http://www.excelforum.com/excel-gene...f-numbers.html

    Stephen Angudubo
    Last edited by Paul; 09-17-2015 at 12:46 PM. Reason: Moved question to new thread, per the rules. Added link to referenced thread.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting repeating groups of cells in a single column into rows
    By B24Mike in forum Excel General
    Replies: 2
    Last Post: 08-12-2015, 07:11 PM
  2. Repeating numbers
    By shawzito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2014, 01:27 AM
  3. [SOLVED] Repeating a date difference formula to groups of varying size.
    By cput in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-23-2012, 08:38 PM
  4. [SOLVED] Without repeating numbers
    By thair in forum Excel General
    Replies: 6
    Last Post: 05-20-2012, 03:12 PM
  5. AutoFill for Repeating Groups of Numbers
    By Jonezee1 in forum Excel General
    Replies: 2
    Last Post: 09-27-2008, 10:47 PM
  6. for repeating numbers!!!
    By p4pints in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2006, 11:26 AM
  7. [SOLVED] REPEATING NUMBERS IN A ROW
    By nazzoli in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-17-2006, 10:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1