Returns the rank of a specified value in a dataset. Sample Usage RANK(A2,A2:A100) RANK(4,A2:A100,1) Syntax RANK(value, data, [is_ascending]) value - The value whose rank will be