+ Reply to Thread
Results 1 to 5 of 5

Quartile calculation based on certain values

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    adelaide
    MS-Off Ver
    Excel 07/10
    Posts
    56

    Quartile calculation based on certain values

    Hi Guys,

    Can someone please have a look at the attached file and help me?

    Quartiles 3.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Quartile calculation based on certain values

    I changed your formula a little to this...
    =IFERROR(VLOOKUP(F9,$H$8:$J$12,MATCH($B$2,$H$7:$J$7,0),1),"")

    It is based off the table which you kind of started in H. Take a look atthe attached, I put the new formula in K (highlighted yellow) so you can compare with what you had. Move it to where you want it when you are satisfied it works
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Quartile calculation based on certain values

    In G9 use and drag down.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-16-2012
    Location
    adelaide
    MS-Off Ver
    Excel 07/10
    Posts
    56

    Re: Quartile calculation based on certain values

    Thank u so very much fdibbins and kv.

    your solution works perfectly!

    I am not sure if a new thread is needed but I would want the column b9 and g9 to talk to each other.
    for eg:
    if B column has team name as x and 10 different consultants, I want it to calculate how many in team x are in top, bottom, middle upper and middle lower.

    team x 4 top, 2 bottom etc - I ideally want a graph of these numbers.

    Can you help?

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Quartile calculation based on certain values

    For "Top" use this.Similarly you can get for others.

    Please Login or Register  to view this content.

+ 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. Upper quartile of values in array next to count of values
    By jamblur in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2013, 06:17 AM
  2. Correlation for 1st quartile, 2nd quartile, 3rd quartile, 4th quartile
    By DexterG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2013, 07:17 AM
  3. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  4. calculation based on the values within a range
    By anirbancd in forum Excel General
    Replies: 3
    Last Post: 03-22-2012, 10:48 AM
  5. calculation based on row and column values
    By AmyTaylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2005, 03:05 PM

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