Ranking Results

%3CLINGO-SUB%20id%3D%22lingo-sub-2437108%22%20slang%3D%22en-US%22%3ERanking%20Results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437108%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Office%20365%20and%20I'd%20like%20to%20know%20how%20I%20could%20rank%20results%20from%20a%20row%20of%20numbers%20to%20the%20same%20row%20in%20different%20cells%20showing%20the%20results.%20I%20have%20attached%20a%20sample%20of%20the%20data.%20I%20want%20the%20results%20ranked%20in%20the%20top%205.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2437108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2437224%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20Results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437224%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20not%20sure%20exactly%20what%20you%20want.%3CBR%20%2F%3EHowever%2C%20a%20RANK%20function%20is%20probably%20what%20you%20are%20looking%20for.%3CBR%20%2F%3ERead%20more%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2437321%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20Results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064156%22%20target%3D%22_blank%22%3E%40StoneKiwi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20and%20yes%20I%20am%20looking%20for%20a%20rank%20function%20however%20that%20article%20is%20based%20on%20an%20average%20calculation.%20I%20have%20added%20more%20detail%20within%20the%20attached%20workbook%20hoping%20that%20will%20provide%20more%20detail.%20My%20apologies%20for%20the%20lack%20of%20a%20proper%20description.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm using Office 365 and I'd like to know how I could rank results from a row of numbers to the same row in different cells showing the results. I have attached a sample of the data. I want the results ranked in the top 5.

3 Replies
Hi,

I am not sure exactly what you want.
However, a RANK function is probably what you are looking for.
Read more here: https://support.microsoft.com/en-us/office/rank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a

@StoneKiwi 

 

Thanks, and yes I am looking for a rank function however that article is based on an average calculation. I have added more detail within the attached workbook hoping that will provide more detail. My apologies for the lack of a proper description.

@62Mojo 

Hi,

 

Please find your excel sheet attached with updated formulas. You will likely have to make some additions to the formulae if you wish to also report the source of the error (e.g. voip vs internet ...)

 

good luck!