Results 1 to 2 of 2

Thread: drag formula for data that skips one cell in other sheet

  1. #1

    drag formula for data that skips one cell in other sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I'm looking for a furmula that will take data from one cell in sheet (=sheet1!A1), than will skip one cell (column) and take the data from the next cell (=sheet1!C1). I have to drag the formula on many cells in a raw...

    Thanks

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,284
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Enter this in your a cell and then drag it across to the right:

    =OFFSET($A$1,0,COLUMN(A1)*2-2)
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

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