percentrank

Hello, I am new to excel and am trying to use and understand the PERCENTRANK formula. Doc says that when the number you are looking for is in your data set, the formula is : lower values / (lower+upper values). The problem is when I try to search for a number that is not included in the data...

I am trying to calculate the percentrank of each annual salary by salary grade level but need to exclude for instance departments that start with "IT ". For those who are in the IT department I would like to see blank and make sure their number is not part of the percentrank calculation. So...

how to calculate percent rank for employee salary with designation and no of year experienc as condition

Hello, So I have a large list of data that is sorted by month and there are about 200 rows of data for each month. To clarify, Column A is a list of the dates and so because there are 200 lines of data for each month, there will be 200 entries of the same date directly to the left of the data...

Hi, I'm trying to use Index, Match with Percentrank but I'm not getting it right. In this sample data, I would like to use Percentrank for "Jan" or "Feb", etc. <tbody> State Jan Feb Mar Alabama 44.29 48.04 55.47 Arizona 42.27 46.24 51.03 Arkansas 38.48 43.76 51.96 California 45.14...

Hello and thank you for your time and help, I am trying to create a function which would extract a subset from a given range depending on the values contained in another range. The final aim is to be able to use the Percentrank function on dynamically changeable groups <tbody> A B C D 1...

I'm trying to use the Percentrank function and I am able to use it right as long as I define my set or group but, I need to set the group dynamically based on another column. Column E = Teacher's Name Column AH = Average grade through the year. In Column AJ I want to see the PercentRank of...