+ Reply to Thread
Results 1 to 2 of 2

Dynamic filter of rows to remove zero value

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    Dynamic filter of rows to remove zero value

    need to filter rows and remove zero values and am using the below formula..


    Please Login or Register  to view this content.
    However, the above code is static. Need to filter dynamically as the number of rows can vary and be greater than 60441.
    Please help in how I can achieve this?

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Dynamic filter of rows to remove zero value

    Maybe:

    Please Login or Register  to view this content.

+ 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. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  2. Dynamically hide rows for dynamic criteria range of advanced filter
    By Senator685 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2013, 02:08 PM
  3. Delete Rows hidden by either Auto Filter and Advanced Filter
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:29 AM
  4. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  5. Replies: 1
    Last Post: 10-23-2012, 09:12 AM

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