+ Reply to Thread
Results 1 to 2 of 2

Is it possible to delete entire row subject to duplicate value in it?

  1. 05-10-2011, 05:12 PM #1
    sami770
    sami770 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Is it possible to delete entire row subject to duplicate value in it?

    Hey guys,
    Could anyone show me how to delete entire row if *ANY* cell in it has the very same value other rows has?

    I mean, to keep the first row that has such value in it but delete all other rows...

    Please see excel sheet attached

    Cells b1, b2, b3 has the very same value, b5 and b6 also share the same value
    I would like to delete the ENTIRE rows 2, 3 and also 6

    is it possible with excel?
    Attached Files Attached Files
    Last edited by sami770; 05-10-2011 at 05:18 PM.
    Reply With QuoteRegister To Reply
  2. 05-11-2011, 07:11 AM #2
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Is it possible to delete entire row subject to duplicate value in it?

    To clarify your problem, can you markup/highlight your sample to show the rows that you expect to be deleted?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1