|I believe you mean that you want to rank a |row</s. column of 30 numbers B3:B33.
Excel Rows are designated by numbers, Columns are designated by letters.
Enter this in C3 to rank your Column B values in descending order. The highest value will be given the lowest rank, the lowest value will be given the highest rank.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.