ranking sort

I want top 3 Unique students ranking filtered from records below along with their details and all the other roll numbers excluding the ones that are once already mentioned once in the left Only that appeared on top 3 in the last column (with Comma separation) D1125A8:I20,J11:N20Cellcontains a...

I couldn't find a place to post this question so I was advised to create a new thread. I'm looking for a formula to calculate the variation from a standard time set e.g. 20:30 (mm:ss). I have around 23 different times in a column and I want to put a formula next to it to find the variation and...

Hi there, I'm trying to create a running leader board for a competition we're holding at work. On a weekly basis, points will be entered in the yellow cells so competitors can keep track of their progress. I've managed to get the "ranking" formulas working (F3-7 and G3-7) however I need the...

Hoping for the excel gods to answer a question. I have data in a row like the example posted below. I want to rank the values (including positive/negative numbers), but need to ignore the zero's since a zero indicates no data was present. I can rank including the zeros, but that throws off the...

Hi, I am not sure if this question has been posted before. I have a sheet of data which has revenue earned by date. Now what i want to do is to compare data day wise for example, I would want to compare revenue earned today, which is wednesday with all the previous wednesday's of the year and...

My Setup <colgroup><col><col><col><col span="2"></colgroup><tbody> name COUNT ATTENDANCE jake 11 536 sue 9 709 betty 10 357 jack 9 1438 trevor 11 1240 </tbody> i am trying to get the ranking based on first the count, then the attendance, the highest of the count...