+ Reply to Thread
Results 1 to 2 of 2

Delete Row if Column returns a value of zero

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    7

    Cool Delete Row if Column returns a value of zero

    Hi everyone,
    I see a lot of different instances on other forums on how to solve this, but none of them really work.

    I have a ton of data (A1:CV350000)

    and in Column A I have a formula that returns a 1 if I want to keep the row and a zero if I want to get rid of it.

    I know this is probably simple, but i'd like the exact macro that would get rid of all of the rows that have a Zero for Column A and keep the rest.

    Thanks for the help.

    Peace and love,

    amweisberg

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Delete Row if Column returns a value of zero

    hello amweisberg and welcome

    maybe something like this would work for you?

    Please Login or Register  to view this content.

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete Sequential Carriage Returns
    By johnph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2012, 01:45 PM
  2. Sort Column, Delete Rows, Delete Column, Move Molumn, more inside?
    By motown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2008, 09:44 AM
  3. delete carriage returns from fields in column
    By caset in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2007, 03:23 AM
  4. [SOLVED] Delete Carriage Returns
    By Andre in forum Excel General
    Replies: 4
    Last Post: 12-01-2005, 07:35 PM
  5. [SOLVED] How can I find and delete tabs and carriage returns ?
    By JeffEE in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 10:55 AM

Tags for this Thread

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