+ Reply to Thread
Results 1 to 3 of 3

Display data in the appropriate row based upon a variable

  1. #1
    Registered User
    Join Date
    06-21-2018
    Location
    Wiltshire, England
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Display data in the appropriate row based upon a variable

    Hello all, .... Is there a way to reproduce the data from col B2:B4, into col C, where the display row is dependant upon the variable in D10. So if D10=3, the data would begin in Row C5 (original data start row plus 3), as below. (apologies for the rubbish format but my IT dept does not allow uploading of a screenshot and any spaces are automatically deleted when previewing so I had to use dashes :-/
    Thank you!
    ----------A-------------B--------------C------------D
    1------Despatch-----Qty----------Delivery----offset days
    2-------21/6---------150
    3-------22/6---------200
    4-------23/6---------300
    5-------24/6-------------------------150
    6-------25/6-------------------------200
    7-------26/6-------------------------300
    8
    9
    10-------------------------------------------------3

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Display data in the appropriate row based upon a variable

    C2=IFERROR(1/(1/OFFSET(C2,D$10*-1,-1)),"")
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    06-21-2018
    Location
    Wiltshire, England
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Re: Display data in the appropriate row based upon a variable

    YAY! ...cool, thank you!

+ 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. [SOLVED] Display data based on combobox value
    By sabeelahmedks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2018, 07:31 AM
  2. Replies: 1
    Last Post: 03-11-2015, 04:07 PM
  3. [SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 09:08 AM
  4. [SOLVED] Formula to display data validation results on another sheet based on data chosen?
    By myoung5149 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2013, 02:53 PM
  5. Filter data based on columns, display unique row data
    By djarcadian in forum Excel General
    Replies: 14
    Last Post: 05-18-2013, 07:18 PM
  6. Replies: 1
    Last Post: 10-27-2012, 02:54 AM
  7. Display time based data in excel - simple play, pause, stop through data - HELP
    By geekyhawkes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2012, 01:55 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