Rank for different Criterion Groups

**Abee** · 12-28-2021, 03:53 AM

Is it possible to get different set of rank for different criterion groups in the same column.
Actually I wish to get each exams rank to be compared with one of its own kind for each student.
For example rank of 1st-Term should be compared with results of 1st-Term of all students.
In the same way the rank of Mid-Term should be compared with results of Mid-Term of all students.
Same for rest of exams and same for 2nd-Term and Final-Term.
Rank of Grand-Total should be compared with results of Grand-Total of all students.

And essentially the rank that a student is achieving after final term in "Grand Total" row.

**JohnTopley** · 12-28-2021, 08:48 AM

Please add sample expected results as your table implies a single result in column AF (based on column Z ?)

in Z9

=SUMIFS(D9:X9,$D$8:$X$8,"OM")

and you cannot add the percentages e.g. F!3: you need to SUM("OM")/SUM("MM") so F13 is 64% not 74.5%

**AliGW** · 12-28-2021, 10:33 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time: https://www.mrexcel.com/board/thread...roups.1191259/)

Rank for different Criterion Groups

LinkBack

Thread Tools

Rate This Thread

Display

Rank for different Criterion Groups

Re: Rank for different Criterion Groups

Re: Rank for different Criterion Groups

Thread Information

Users Browsing this Thread

Similar Threads

Assign Bucket of Values to Groups by Rank

[SOLVED] Formula to RANK groups of Values and return letter

[SOLVED] Help require to modify rank formula for subject groups

[SOLVED] Formula to RANK groups of values.

Create or rank work groups based on preferences

Rank items within groups

One list unsorted, but two groups - I need to rank in each group

Bookmarks

Bookmarks

Posting Permissions