Results 1 to 2 of 2

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

Threaded View

  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
« 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