Announcement

Collapse
No announcement yet.

Automatically Re-Apply Auto Filter When Data Changes

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 12:49.

  • #2
    Re: Report & Calculate By Each Countries State

    See my second reply here
    http://www.ozgrid.com/forum/showthread.php?t=59917

    Comment


    • #3
      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

      Comment

      Working...
      X