Excel- rank error

Question

Hello, good afternoon everyone. I have a project that deals with computer sciences, my issue is whenever I type in rank function, I always get an error. I have try that will many of the active cell text box and it works. I have try everything from using an errorif function, it still doesn't work. I have being getting the same #value error for almost two days. I have no idea what to do and the teacher guides us but doesn't really help us since it's considered as a School Based Assessment. Does anyone in this community has an idea of this problem. Also I'm using Excel 2016. Please respond as soon as possible.

Answer 1

The RANK Function has the following form:

=RANK(a cell, a range of cells, (optional) an order)

If an order is 0 (zero) or omitted, Microsoft Excel ranks number as if the range of cells were a list sorted in descending order.

If order is any nonzero value, Microsoft Excel ranks number as if the range of cells were a list sorted in ascending order

7 3.5 3.5 1 2

=RANK(A3,A2:A6,1) This will return 3 as 3.5 is ranked 3rd in the list

If you still cannot get the RANK function to work, please post the formula you are using and a sample of the data . . .

Answer 2

Could you please upload a sample sheet sans confidential data one one drive or google drive or drop box or any other file host?

This will help the community to provide right answer.

Answer 3

Please try the following solution of repairing your office package:

The first thing you can do is to navigate and select the start button 2) Type in control panel 3) Navigate to "Programs". 4) Then select "Uninstall a Program" 5) Then find your office installation and right click (Usually say Microsoft Office 2016 or something similar) 6) Select change 7) Now a window will pop asking for "Quick Repair" or "Online Repair" 8) Select the Quick Repair option and reboot 9) If the problem continues select the Online Repair option and reboot

Please let me know if this helped or not, i will happily assist you further.

Kind Regards Phillip Roos

Answer 4

Ciao,

can you please share a screenshot to clarify your issue?

Thanks Ugo