Results 1 to 3 of 3

Thread: formula to return data from cell

  1. #1

    Cool formula to return data from cell



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

    Hi there,

    I have data in Cell A1 - A100. If I am sitting in Cell B1. How can I bring back data from Cell A2 & cope the formula down?

    Many thanks

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    In cell B1, type this:
    =A1

    Then double click on the small black box on the bottom right corner of cell B1, and the formula will be copied down.

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Hello EVAI
    If I understand correctly, you are wanting to show values in Col B based on whats in Col A , but offset by one row.

    If this is correct, type =A2 in cell B1, then drag this down to cell B99, or double click as Jeffrey has described. You say you have data in A1 as well, but Im assuming that this
    might be (e.g.) labelling that you dont want in Col B.

    HTH
    Hercules

Posting Permissions

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