ranks

Thanks in advance for any pointers! I have a list of Percentages like this: 102.60% 101.90% 101.80% 101.20% 101.00% 100.80% 100.60% 100.50% 99.90% 99.80% 99.80% 99.80% 99.40% 99.10% 98.70% I need a formula that looks at this range and ranks the results 1-5 based on what percentage those...

I have a column with different values from 0 to 100. I would like to group those values into consecutive groups of 20 values , sum those values and rank them depending on which sums are the greater and point me to where those values are. Ideally the ranks would be divided into the highest sum of...

Hello everyone, I'm new to the forum, but I look forward to contributing to other peoples questions in the future! I currently have a question involving a scenario where I want to rank pairs of data while ignoring any duplicates in the data. What I am working with is located below. Column A is...

Hello everyone, I'm trying to build a reporting spreadsheet so I can manage some of my team members grades (which can be from 1 to 10). This will help me with an AVERAGE() formula formatted to show a percentage of satisfaction from clients/colleagues :) Now, I have the following table...

I need a big help from experts. =] After a day-research, I learned how to rank entries from multiple groups. I ranked column D (A+B groups having highest C value) using sumproduct..But I need to skip duplicates in this column, and retain sequential orders. (1, 2, 3, 4...Not 1, 2, then 4!) I...