Results 1 to 10 of 51

Thread: VBA - Count filtered rows in the table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #30
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,378
    Rep Power
    10
    Quote Originally Posted by sandy666 View Post
    it should be a proper result

    Count
    Total rows: 100
    Name filter: 86 Left / Filtered 14
    Region filter: 82 Left / Filtered 4
    Country filter: 79 Left / Filtered 3
    I don't think so, still does not look right
    Quote Originally Posted by DocAElstein View Post

    My results:
    Code:
     "name filter rr ll : 80 Left / Filtered 20
    Region filter sh : 78 Left / Filtered 2
    Country filter us : 75 Left / Filtered 3
    
    "
    or you are not telling me something

    I am going jogging in the Sun
    Last edited by DocAElstein; 08-29-2023 at 02:19 PM.

Similar Threads

  1. Replies: 101
    Last Post: 06-11-2020, 02:01 PM
  2. Delete Filtered Rows Excluding The Header
    By xander1981 in forum Excel Help
    Replies: 5
    Last Post: 04-01-2014, 11:44 PM
  3. Replies: 1
    Last Post: 07-30-2013, 11:08 PM
  4. Lookup and Count Using Pivot Table
    By RobExcel in forum Excel Help
    Replies: 2
    Last Post: 12-21-2012, 11:08 AM
  5. Unique Count on a Filtered Range
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 04:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •