+ Reply to Thread
Results 1 to 3 of 3

Insert Row When value changes in column without Macro

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Long Beach
    MS-Off Ver
    Excel 2007
    Posts
    14

    Insert Row When value changes in column without Macro

    I would like to automatically insert a row at each change in value in one column. See the attached sample. When the value in column C changes, I would like a row inserted. Preferrably without using any macros because they are way beyond my skill level and understanding
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    721

    Re: Insert Row When value changes in column without Macro

    why you want to insert the row?
    think another way that can solve your problem.

    There is no formula for inserting the row without Macro.

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    Long Beach
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Insert Row When value changes in column without Macro

    I have a large list of 30,000 lines and only want to delete duplicates within a group of these rows based on the same values in one column. It's not critical to have, just a convenience thing.

+ 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