+ Reply to Thread
Results 1 to 9 of 9

want to replicate everything four times

  1. 11-09-2018, 07:48 AM #1
    Vali_ro
    Vali_ro is offline
    Registered User
    Join Date
    11-09-2018
    Location
    Timisoara
    MS-Off Ver
    2016
    Posts
    4

    want to replicate everything four times

    Hi guys,
    I'm looking for a formula to complete a worksheet based on some references in another sheet.
    Pls see attached. Capture.JPG
    Last edited by Vali_ro; 11-09-2018 at 08:12 AM.
    Reply With QuoteRegister To Reply
  2. 11-09-2018, 07:49 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: problem with references

    Erm ...

    Welcome to the forum, by the way!

    Your title and visual are both far too vague - what exactly are you trying to do?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 11-09-2018, 07:57 AM #3
    Vali_ro
    Vali_ro is offline
    Registered User
    Join Date
    11-09-2018
    Location
    Timisoara
    MS-Off Ver
    2016
    Posts
    4

    Re: problem with references

    Hi,
    Thanks for the warm welcome,btw.
    Excel newb here. Is this making more sense?
    Capture.JPG
    Reply With QuoteRegister To Reply
  4. 11-09-2018, 07:58 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: problem with references

    So you want to replicate everything four times?
    Reply With QuoteRegister To Reply
  5. 11-09-2018, 08:04 AM #5
    Vali_ro
    Vali_ro is offline
    Registered User
    Join Date
    11-09-2018
    Location
    Timisoara
    MS-Off Ver
    2016
    Posts
    4

    Re: problem with references

    Indeed , this is the final goal.
    Reply With QuoteRegister To Reply
  6. 11-09-2018, 08:10 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: problem with references

    OK - please adjust the title of the thread via your opening post (Edit - Go Advanced) to reflect what you are trying to do. Thanks!
    Reply With QuoteRegister To Reply
  7. 11-09-2018, 08:11 AM #7
    gondal
    gondal is offline
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: problem with references

    please try this,

    =INDEX($A$1:$A$18,INT((ROWS(B$1:B1)-1)/4)+1)
    Reply With QuoteRegister To Reply
  8. 11-09-2018, 08:22 AM #8
    Vali_ro
    Vali_ro is offline
    Registered User
    Join Date
    11-09-2018
    Location
    Timisoara
    MS-Off Ver
    2016
    Posts
    4

    Re: want to replicate everything four times

    gondal,
    works like a charm..now I am trying to understand how it's structured
    Thanks a bunch!
    Reply With QuoteRegister To Reply
  9. 11-09-2018, 08:27 AM #9
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: want to replicate everything four times

    ...another approach of course and not using formulae would be to copy A1:A15 and paste it three times in A16, A31 and A46, then sort column A.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Please help with macro problem - the use of absolute references $$ (using the F4 key)
    By KaraBadara in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 12:31 PM
  2. Chart problem with cell references
    By ExcelsiorLux in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 08:14 AM
  3. [SOLVED] Problem with Word 12.0 and 14.0 references
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2012, 07:38 AM
  4. Problem with macro references.
    By mlopardo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 01:02 PM
  5. Problem with references/variables
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2005, 01:05 PM
  6. Big problem with references in formulas
    By kayard in forum Excel General
    Replies: 5
    Last Post: 07-18-2005, 06:05 PM
  7. Problem with references in a formula
    By BittyBite in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 06:47 AM
  8. [SOLVED] Problem updating references
    By VanS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-19-2005, 06:06 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