Hi:

I have a list of results from art auctions of various sizes.Here is a chunk:

30-Nov-82 11 30 1982 611.1 112
30-Nov-82 11 30 1982 612 113
30-Nov-82 11 30 1982 613 114
30-Nov-82 11 30 1982 614 115
28-Jun-83 6 28 1983 401 1
28-Jun-83 6 28 1983 402 2
28-Jun-83 6 28 1983 403 3
28-Jun-83 6 28 1983 404 4

I've ordered the lots according to auction successfully usuing a jimmyrigged function bc some lots are like 12, 12A or like 12, 13. This is the farthest column right and you see here two separate auctions up against each other.

My real question: I need to put the lots into percentiles based on their order. Im thinking of breaking up each auction into groups of 5. For example, in a ten lot auction, the coulmn would read down: 1 1 2 2 3 3 4 4 5 5, as the rank went 1 2 3 4 5 6 7 8 9 10. Since the auctions are of various lengths--some have 100 lots, some have 50--I dont know what the formula could/would be so I could start at the top and drag it throughout a column.

Any help would be appreciated. Thanks!