+ Reply to Thread
Results 1 to 4 of 4

Filter 10% highest value of a column

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Cool Filter 10% highest value of a column

    Good afternoon community
    I want to filter the 10% highest value of the column H.
    Do you know which formula is working? The worksheet to find these data is below "CI_Accessory_Template.xlsm".
    Thank you in advance for your help.

    Capture.PNG

    Have a good day.
    Attached Files Attached Files
    Last edited by Luu4466; 11-18-2020 at 03:45 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Filter 10% highest value of a column

    Have you tried to use built in filtering? You can use top10 filter and set it to top 10 percent
    Attached Images Attached Images
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: Filter 10% highest value of a column

    Kaper, you save my life. Thank you.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Filter 10% highest value of a column

    Glad to hear it worked, and thanks for marking this thread as SOLVED.

    You may not be aware that on our forum you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given (and accepting in pop-up window - some webbrowsers do block this pop-up). By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Filter highest diploma
    By beroberobero in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2019, 06:27 AM
  2. Replies: 17
    Last Post: 11-08-2018, 11:32 PM
  3. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  4. Unselecting highest - lowest filter
    By Elainefish in forum Excel General
    Replies: 2
    Last Post: 05-13-2014, 01:51 PM
  5. Search column for highest value, then second highest, etc.
    By MDPlanner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2010, 10:39 AM
  6. Picking the highest value from a column and then the next highest
    By johnb28 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2008, 01:20 PM
  7. Replies: 3
    Last Post: 08-10-2006, 11:40 PM

Tags for this Thread

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