Actually, this might look better

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

"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?