+ Reply to Thread
Results 1 to 2 of 2

Formula for a condition in one cell and post answer in other column

  1. #1
    Registered User
    Join Date
    03-28-2008
    Posts
    26

    dynamic ranges

    sample of data below:

    1 -69720 69670
    1 FALSE 69700
    1 FALSE 69700
    1 FALSE 69940
    1 FALSE 69940
    1 FALSE 69940
    1 69940 69940
    1 FALSE 69970
    1 FALSE 69970
    1 FALSE 69970
    1 FALSE 70110
    1 70110 70110
    1 70110 70110
    1 70110 70110
    -1 0 0
    -1 70100 0
    -1 FALSE 0
    -1 FALSE 0
    1 FALSE 0
    1 70100 0


    What I want to do is I need to do is sort of complex I think. What I'm trying to do is post info to column d which is blank based on mutliple conditions.

    Any time the first column (a) changes from 0,or 1,or -1 post a number the number from column "b" to column "d". Then after that if column "b" has a number in it and column "a"'s value hasnt changed then post value from column "b" to column "d" and dont post anything else in column "d" until the value in column "a" changes to 0, or 1, or -1.

    Below is what it should look like when the formula is written in column "d"

    1 -69720 69670 -69720
    1 FALSE 69700
    1 FALSE 69700
    1 FALSE 69940
    1 FALSE 69940
    1 FALSE 69940
    1 69940 69940 69940
    1 FALSE 69970
    1 FALSE 69970
    1 FALSE 69970
    1 FALSE 70110
    1 70110 70110
    1 70110 70110
    1 70110 70110
    -1 0 0
    -1 70100 70150 -70100
    -1 FALSE 70140
    -1 FALSE 70140
    1 FALSE 70140
    1 70100 70150 70100


    Please find a sample spreadsheet attached
    Attached Files Attached Files
    Last edited by tradermike; 04-01-2008 at 09:56 PM.

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Hi,
    Your description is confusing...

    And there seems to be inconsistencies in the data you posted:

    What is the difference in your criteria between:

    1 69940 69940

    and

    1 70110 70110

    or

    -1 70100 70150

    In the first you want a value in column D, in the second you dont and in the third you do...

    What values can column A have to define the conditions?

    This said:
    If you are looking for a formula that take cell changes rather that cell values I´m afraid you have an impossible problem on your hand. Maybe VB can do it for you, but using a simple formula cant.
    Last edited by Portuga; 04-02-2008 at 01:36 AM.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ 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