Results 1 to 8 of 8

Delete the first occurrence for specific value

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Delete the first occurrence for specific value

    Hello everyone
    I have values in five columns B:F and I would like to search for the value 1 in these values
    The issue I need is to delete the sets (rows) that occurs first in sequence

    For example :
    In row 5 and 6 the value occurred twice so I would need to delete row 5 (the first occurrence)

    Another instance:
    In row 9 the value 1 is existing but no values in row before neither row after so this will NOT be deleted (kept)

    Another instance:
    In rows 12 & 13 & 14 & 15 : the value existed in these rows so the first one would be deleted only

    Attachment would illustrate it better
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find specified occurrence of specific text string?
    By mrbusto71 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 10:44 PM
  2. Find last occurrence of a string in a specific column
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2016, 11:39 AM
  3. [SOLVED] Count last occurrence for specific values in range
    By YasserKhalil in forum Excel General
    Replies: 2
    Last Post: 01-12-2016, 05:08 AM
  4. How to move a specific occurrence of rows into a new sheet.
    By sugaprasad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2015, 08:42 AM
  5. Is that possible to track the occurrence of number in specific cells?
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 05:23 AM
  6. How to Delete Text Before First Occurrence Of Character?
    By JimMW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 11:06 AM
  7. Replies: 3
    Last Post: 08-16-2010, 04:29 PM

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