Ranking by formula

[shimaa01234]

In the file, there are two columns
In the first - there are a number of teachers
In the second - no average application
Iwant -If decreased the number of teachers, and increased
The average application
Ranking as it exists in the column "D"

[shimaa01234]

The idea is simply
If decreased the number of teachers and the average application is high
The Ranking Will be advanced

[Glenn Kennedy]

The first 7 teachers in the list have the same score, but you have given them different ranks. Was that intentional? Does it matter which teacher is ranked 1, which one is ranked 2, etc?

[Glenn Kennedy]

Never mind. I figured it out. Try this.

[shimaa01234]

This solution reached but by columns Help
On Can be executed without these columns

[Glenn Kennedy]

My formula took assigned a rank to the number of teachers; the smaller the teacher number, the lower ranking number (i.e. closer to 1). I then took the applications - the higher then no. of applications the lower the ranking number (again, closer to 1). I added these together. the lower that number is, the better. I then ranked those numbers in ascending order.

I do not really follow the logic behind what you did. Nor do I understand what you have said in post 5.

[shimaa01234]

Yes you did it
Very clever solution
But can the solution without columns Help

[Glenn Kennedy]

It MAY be possible, but I can't see a way to do so easily. Can't you just hide the heper column?

[shimaa01234]

Anyway, your solution genius
Thank you very much for this wonderful help
God bless you

[Glenn Kennedy]

You're welcome & thanks for the Reputation.

[azumi]

Just add suggestion for formula from Glenn, if you need exclude helper column:

Put this highlited text:
=SMALL($B$3:$B$123,B3)+RANK(C3,$C$3:$C$123)+ROW()*0,00000000001

to highlited text:

=RANK(E3,$E$3:$E$123,1)

cheers

[shimaa01234]

Your Solution beautiful Mister "azumi"
But also the same idea
Can the solution without columns Help

[Glenn Kennedy]

I started off doing something like that too, azumi, and then got hopelessly lost...

[bebo021999]

@ Shimaa01234:

Without helper, upgrade Glenn's:

Please Login or Register  to view this content.

Same result with Glenn's, but differ from yours, such as:row 14 to 19

[kvsrinivasamurthy]

Pl see attached file.
Using your formula rank formula derived.
In 3rd row, then drag down

Please Login or Register  to view this content.

[shimaa01234]

Thank you very much, Mr. "bebo021999"
Thank you very much, Mr. "Kvsrinivasamurthy"
Yes, this is required
God bless you all