In B1 enter:

=RANK(A1,A$1:A$5,1) and copy down
--
Gary''s Student - gsnu201001


"Eric E" wrote:

I have a list of random numbers in column A, in column B I would like the
number 1 to show up next to the lowest number in column A. I can't use sort
because each random number is in a group of 3 rows that I need to keep
together. I am looking for something like this, A containing the random
number, B containing the order of the numbers in column A.

A B
1 16 3
2 8 1
3 52 5
4 12 2
5 19 4

Does anyone even know if this is even possible?