Results 1 to 5 of 5

Thread: Repeat A Value In A Predefined Number Of Rows Using Formula

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Repeat A Value In A Predefined Number Of Rows Using Formula

    Required
    1 re-repeating number 100 in column A
    Without pulling down cell
    ineed that by formula , no code
    I think I reached resolve in the sheet (AA 2)
    Attached Files Attached Files
    Last edited by mahmoud-lee; 05-31-2013 at 09:02 PM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    =IF($B$2>=(ROW($A$2:$A$380)-1),$C$2,"") would be a much simpler approach
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Ingenious solution and beauty of simplicity

    If I want the solution by code?

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Code:
    Sub RepeatValue()
    
        Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row).ClearContents
        Range("A2").Resize(Range("B2").Value).Value = Range("C2").Value
        
    End Sub
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    you are very kind thanks a lot

Similar Threads

  1. Nth Day Of Week Number Using Formula
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 06-16-2013, 06:40 PM
  2. Replies: 4
    Last Post: 06-09-2013, 01:47 AM
  3. Number 9.99999999E+307 in Excel Formula
    By Admin in forum Familiar with Commands and Formulas
    Replies: 0
    Last Post: 06-11-2012, 04:09 PM
  4. Insert 'n' number Rows after any specified row no.
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 11-08-2011, 08:59 AM
  5. Replies: 2
    Last Post: 05-06-2011, 02:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •