see Rank function: for rank of column b

=rank(b1,b1:b100,0)

ranks highest to lowest

change ,0 to , 1 for lowest to highest

__________________
not a professional, just trying to assist.....