+ Reply to Thread
Results 1 to 2 of 2

Insert New Row When Column Amount Changes

  1. #1
    Ronald \Tony\ Johnson
    Guest

    Insert New Row When Column Amount Changes

    Here is an example of what I am talking about.

    A B C D
    1 A B C D
    2 2 41100 274 584
    3 2 41100 274 625
    4 2 41100 274 333
    5 2 41100 274 102
    6 2 41100 274 957
    7 2 41100 274 362
    8 2 41100 274 651
    9 2 41100 274 611
    10 2 41100 284 965
    11 2 41100 284 336
    12 2 41100 284 251
    13 2 41100 284 362
    14 2 41100 284 859
    15 2 41100 284 512
    16 2 41100 284 669
    17 2 41100 284 512


    I need to insert a new row every time the amount in Column "C"
    changes to a different amount than the previous one.
    There are approx 16,000 rows in this file or I would not be asking..lol

    Thanks for any help you can offer.


    --
    Tony Johnson

    --
    Tony Johnson

  2. #2
    Debra Dalgleish
    Guest

    Re: Insert New Row When Column Amount Changes

    In cell E2, enter the formula:

    =IF(C2=C1,"X",1)

    Fill the formula down to the last row of data
    Select column E
    Choose Edit>Go to
    Click the Special button
    Select Formula, and remove the check marks from Text, Logicals and Errors
    Click OK
    Choose Insert>Rows
    Delete Column E

    Ronald \"Tony\" Johnson wrote:
    > Here is an example of what I am talking about.
    >
    > A B C D
    > 1 A B C D
    > 2 2 41100 274 584
    > 3 2 41100 274 625
    > 4 2 41100 274 333
    > 5 2 41100 274 102
    > 6 2 41100 274 957
    > 7 2 41100 274 362
    > 8 2 41100 274 651
    > 9 2 41100 274 611
    > 10 2 41100 284 965
    > 11 2 41100 284 336
    >
    > I need to insert a new row every time the amount in Column "C"
    > changes to a different amount than the previous one.
    > There are approx 16,000 rows in this file or I would not be asking..lol
    >
    > Thanks for any help you can offer.


    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ 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