Results 1 to 2 of 2

Thread: Need help with my calculation on 95th and 50th percentiles.

  1. #1

    Need help with my calculation on 95th and 50th percentiles.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello i am new to excel, i need help with my calculation, im not too familiar with the syntax and the percentile function. My calculation calculates every percentile in 'Group', but i dont want it to, i need it to calculate every percentile in each subgroup (ID) in each 'Group'. Can someone please point me in the right direction ? Copy of Copy of EXAMPLE1 (2).xlsx

  2. #2
    Try this array formula

    =PERCENTILE(IF(C2:C10="SW",F2:F10),0.95)

Posting Permissions

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