+ Reply to Thread
Results 1 to 2 of 2

returning values from columns to another sheet, based on conditions

  1. #1
    Registered User
    Join Date
    09-26-2005
    Posts
    4

    returning values from columns to another sheet, based on conditions

    I have set up a spreadsheet where I record certain info in columns on one sheet (sheet A) then produce statistics based on that info on other sheets. When more data is collected, it is entered in the next column. Then I manually go the another sheet and write in the formulas to produce statistics. I want to set up a way to do this automatically.

    For example, if column A contains a name, then I would like to return the 4th cell of column A on column A of another sheet. The same for column B, and so forth. I can do this, but I have to keep entering formulas in all the columns each time I enter more data. Is there a way to do this so that when I enter the data, the stats are compiled automatically in a subsequent col on the other sheets?

  2. #2
    Tom Ogilvy
    Guest

    Re: returning values from columns to another sheet, based on conditions

    On the other sheet in the appropropriate cell of column A (sheet1 is the
    first sheet you spoke of that may contain the name ("Name"))

    =if(countif(Sheet1!A:A,"Name")>0,Sheet1!A4,"")

    --
    Regards,
    Tom Ogilvy


    "zangief" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I have set up a spreadsheet where I record certain info in columns on
    > one sheet (sheet A) then produce statistics based on that info on other
    > sheets. When more data is collected, it is entered in the next column.
    > Then I manually go the another sheet and write in the formulas to
    > produce statistics. I want to set up a way to do this automatically.
    >
    > For example, if column A contains a name, then I would like to return
    > the 4th cell of column A on column A of another sheet. The same for
    > column B, and so forth. I can do this, but I have to keep entering
    > formulas in all the columns each time I enter more data. Is there a way
    > to do this so that when I enter the data, the stats are compiled
    > automatically in a subsequent col on the other sheets?
    >
    >
    > --
    > zangief
    > ------------------------------------------------------------------------
    > zangief's Profile:

    http://www.excelforum.com/member.php...o&userid=27560
    > View this thread: http://www.excelforum.com/showthread...hreadid=470854
    >




+ 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