Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Automatically Re-Apply Auto Filter When Data Changes

  1. #1
    Join Date
    25th April 2008
    Posts
    10

    Automatically Re-Apply Auto Filter When Data Changes

    SPLIT FROM

    http://www.ozgrid.com/forum/showthread.php?t=89732


    Dave,
    Thanks. Setting up all 50 states was not so bad, and I tried a Pivot Table but I have very little experience with them and could not figure out how to show only the nonzero states. So, I looked up how to filter the pivot table and discovered I could just filter the state data without the pivot table.

    So, I put all 50 state abbreviations in one column. In the next column I put countif formulas to count how many customers came from each state. (In the meantime, I learned how to use an indirect formula to pull the state ID from the first column and copy it down and have the formula advance for each row... cool!) Then, I filtered the columns on the count twice. First, in descending order; then, without the zeros.

    However, the weak side of the filter is that it does not automatically update when a new state is entered. I have to go and manually filter again. So, is there a way to get the filter to update dynamically? I know that a pivot table is dynamic but I have a lot to learn and I can probably browse around and figure out how to show only the nonzero states. Once I learned that, would it dynamically update when a new state is added?

    Thanks again.
    James
    Last edited by Dave Hawley; April 26th, 2008 at 12:49.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

  3. #3
    Join Date
    25th April 2008
    Posts
    10

    Re: Report & Calculate By Each Countries State

    That is amazing! One day I am going to study, read, and understand this! :^)
    Thanks so much. This really does it!
    James

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Apply Auto Filter To Non-Continuous Columns
    By balamban in forum EXCEL HELP
    Replies: 4
    Last Post: August 7th, 2008, 17:57
  2. Apply Auto Filter To Active Range
    By ldench in forum EXCEL HELP
    Replies: 2
    Last Post: August 5th, 2008, 19:37
  3. Automatically set auto filter to show all
    By Excelman in forum EXCEL HELP
    Replies: 4
    Last Post: September 23rd, 2005, 23:15
  4. Auto Update for Advanced Filter & Sort Data
    By limjian85 in forum EXCEL HELP
    Replies: 3
    Last Post: February 25th, 2005, 00:45
  5. COUNTIF data after applying Auto filter
    By hyperdreamz in forum EXCEL HELP
    Replies: 34
    Last Post: December 30th, 2004, 23:20

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
  •  
porno