H
HK
I'm trying to build a spreadsheet to manage results from a race. The racers
can be in one of 7 different categories.
In column A, I want to rank the racer's finish, 1-x, x being the number of
racers for that category. In column H, I have the category for each racer.
In column I, I have the race times which I will use to sort my list.
I'm having trouble with the formula in column A, the rank. I have no way of
knowing how many racers are in each category so I can't just pre-enter a
series of numbers. I have to enter a series, starting from 1 and then reset
that series to 1 each time the value in column H changes.
Can anyone help with a worksheet function or formula?
Thanks.
can be in one of 7 different categories.
In column A, I want to rank the racer's finish, 1-x, x being the number of
racers for that category. In column H, I have the category for each racer.
In column I, I have the race times which I will use to sort my list.
I'm having trouble with the formula in column A, the rank. I have no way of
knowing how many racers are in each category so I can't just pre-enter a
series of numbers. I have to enter a series, starting from 1 and then reset
that series to 1 each time the value in column H changes.
Can anyone help with a worksheet function or formula?
Thanks.