How to use the RANK Function in Microsoft Excel

=RANK (number, ref, [order])

See Explanation

Explanation:

Literally, the rank function is used to rank values (i.e. cells) in a particular order (either ascending or descending).

Take the following instances:

A column used for total sales can use rank function to rank its cells from top sales to least.

A cell used for time can also use the rank function to rank its cells from the fastest time to slowest.

The syntax of the rank function is:

=RANK (number, ref, [order])

Which means:

The rank number

The range of cells to rank

The order of ranking i.e. ascending or descending. This is optional.

if you have a hp laptop on the top row of your keyboard there sould be a button that says prt sc , click that then wait a second then open the paint app open the clipboard and hit paste then save as a file. hope that ^-^