Results 1 to 5 of 5

Delete Rows if a value in column A appears only once

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Delete Rows if a value in column A appears only once

    Hi I was wondering if it is possible to delete rows if a value appears only 1 time in a column? To clarify since 123 only appears once in column A I want the entire row 4 deleted. Is this possible?

    Sample Set of Data
    Item #	   Description	                             Cs/Cnt   Exp Date   P. S.	P. E. 
    64	         DEF                                     15   4/27/2009	  23	 23
    64	         DEF                                     15   5/3/2009	  38	 38
    64	         DEF                                     15   5/4/2009	  12	 12
    123	         abc	                                  1    6/4/2009	  22     22
    Last edited by randell.graybill; 04-07-2009 at 03:24 AM.

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