in excel, when i start typing the rank function, the help pops up and gives me the format of the function as: rank(number, ref, [order]). this means 'order' is an optional parameter.