Results 1 to 5 of 5

Excel 2007 : Conditional deleting

Threaded View

  1. 12-28-2009, 11:56 AM #2
    scaffdog845
    scaffdog845 is offline
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Re: Conditional deleting

    CarlBe

    Welcome to the forum. I'm sure one of the Gurus have a cleaner solution but this can easily be done with helper columns.

    Assuming you list of Emails starts in column "A" on sheet 1, place the formula 
    =IF(Sheet1!B1=1,Sheet1!A1,"")
    in cel A1 on sheet 2 and copy down to atleast row 2000. Apply a filter to sheet 2 and have it not show the blanks.

    I've attached a sample.
    Attached Files Attached Files
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.
    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