Results 1 to 8 of 8

Change row input!

Threaded View

Guest Change row input! 08-24-2011, 12:04 PM
ChemistB Re: Change row input! 08-24-2011, 12:17 PM
Guest Re: Change row input! 08-24-2011, 12:36 PM
ChemistB Re: Change row input! 08-24-2011, 12:39 PM
Guest Re: Change row input! 08-24-2011, 01:06 PM
royUK Re: Change row input! 08-24-2011, 01:31 PM
Guest Re: Change row input! 08-25-2011, 07:50 AM
ChemistB Re: Change row input! 08-25-2011, 09:11 AM
  1. #1
    stewart08
    Guest

    Change row input!

    Hi exceler's
    Got a problem being trying to solve for the last few hours, which may or not use the OFFSET function:

    The function has a input value to return a answer from a row of digits.
    Simply the 'row input value' locates ref row (if 1, its 1 row up...) and then adds the right cell vaule.

    rows = 1 input means use 1: row up, 2: use 2 rows up etc...

    values anwers row
    A1: B1: C1: D1:
    8 0 Row 2
    1 0
    2 6
    3 2
    1 1
    6 3
    6 5
    7 1
    8 2
    3 4


    work sheet file
    Last edited by royUK; 08-24-2011 at 01:31 PM.

Thread Information

Users Browsing this Thread

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

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