+ Reply to Thread
Results 1 to 3 of 3

Autofill: Change direction

  1. #1
    Registered User
    Join Date
    09-06-2008
    Location
    Germany
    Posts
    2

    Autofill: Change direction

    Hello everybody,

    Thanks for taking my question.

    I would like to autofill the following(either by using the autofill function or whatever other kind of solution):

    =RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)

    in a way that the column changes

    the result should look like this:

    =RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)
    =RIGHT(Tabelle2!B$4;LEN(Tabelle2!B$4)-FIND(":";Tabelle2!B$4)-1)
    =RIGHT(Tabelle2!C$4;LEN(Tabelle2!C$4)-FIND(":";Tabelle2!C$4)-1)
    .
    .
    .

    Yet, since I'm autofilling downwards (the formulas are in one column), it won't change anything. The number is not changing for the dollar signs - and this is okay. What I would like to change is the columns' reference.

    Is there any possibility to do this?

    Thanks for helping,

    Cheers,
    Andy
    Last edited by adonis85; 09-06-2008 at 08:20 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    =offset()

    If I understand correctly, as the formula is Copied down, column reference should increase.
    In that case, use something like this:
    =OFFSET(Tabelle2!A$4;0;ROWS(Tabelle2!$A$1:A1)-1)

    Hope this helped
    Ola

  3. #3
    Registered User
    Join Date
    09-06-2008
    Location
    Germany
    Posts
    2
    Quote Originally Posted by olasa View Post
    Hope this helped
    Ola
    This helped a lot!

    Thank you so much!

+ Reply to Thread

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