• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Find row that is 75% of filtered list [SOLVED]

    Perfect! Many thanks. One quick question though, why the 2 at the beginning of the MATCH statement? I understand the rest of the formula, just not that part...
  2. F

    Find row that is 75% of filtered list [SOLVED]

    workbook at this link https://docs.google.com/open?id=0ByySPiNwaEgwSzJxY2U5SzdHRms I need to find the value from column D where the row is 75% of the filtered list where there is a figure in column D of the filtered list and is in ascending order in column D
  3. F

    Find row that is 75% of filtered list [SOLVED]

    Yes, that will give the row, but how to do that on a filtered list....so where would the COUNTIFs statement be in that formula? One thing I forgot to mention, the filtered list would need to be sorted in ascending order on the Number of Days column
  4. F

    Find row that is 75% of filtered list [SOLVED]

    Hi all, I have a large list that needs to be filtered based on certain criteria, and of that filtered list, I need to find which row is a 75% of the total filtered row count. An example: A list with approx 6000 rows in with columns of ID, Type, Date, Number of Days The list needs to be...
Back
Top