Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Filtering filtered data

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    After autofiltering data and while the autofilter is open, is there any way to refilter the data. For example, after filtering 100 rows down to 5 rows, I would like to find the second highest of the five (not the second highest of the original 100).

    I know it can be done by copying and pasting the filtered data to another sheet and then running the large function to find the second largest. I would prefer a simpler and more elegant way to do this. The result of this operation will be assigned to a variable and then no further use is needed for the filtered data.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can filter in cascade as many time as you wish on the same data set. The new custom conditions are going to be applied on the filtered data set.

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi tanda:
    To elaborate what Corni mentioned, following is a step by step approach to get the TOP values from filtered dataset
    1) let us say I have my original data in cells G7 through G12

    original data
    21
    70
    80
    95
    67
    43

    2) I want to filter this data with a custom filter applied so that rows with >=43 are selected ... my filtered data is shown below
    70
    80
    95
    67
    43

    3) now I want to pick up the TOP three values from this filtered selection -- my selection is hown below
    70
    80
    95

    4) I can even go a step further and sort this select list, say in descending order to see my list from largest of the three, then the next largest, and so on -- my sorted TOP three list is shown below
    95
    80
    70

    I apologize if it is too much detail for you.
    HTH
    Please post back if it works for you ... otherwise explain a little further and let us take it from there!



    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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