Ranking Formula

[Max Alejandro Molina]

Hello Excel Ninjas,

Can anybody help me find the formulas that can help me get the results on green area (see attached)?


Thank you so much!

 

[alhassan]

Hello Max

I have downloaded your file but i dont understand what you require from excel.
Do you want a formular to rank the figures under "column L" ?

Please feedback

Regards

 

[blazy]

Hello,

see attached.. It is not yet finished, I hope I will point someone in the right direcion... I am also looking forward to the solution, since I dont have time to solve it compeltely on my own

 

[Nebu]

Hi:

Please find the attached. I have pulled a pivot to get the results.

Thanks

 

[blazy]

ohhhh, duuuhhh!!! how could I missed that?? thanks nebu!

 

[Max Alejandro Molina]

Thank you! I did not know you could do that with a pivot table!