Forum Discussion
Need major help!
Hi everyone. I've hit a wall and need some help! I'm trying to put together a workbook where the first page is registration info and following sheets are score sheets. Once a child is registered, they are assigned a group based on age, which I have done using a date formula. However, once they are assigned to the groups, the order of their contestant numbers depends upon their order of registration. The first registered should be the highest number, and the last registered should be the lowest number in order. How can I get excel to assign contestant numbers based on this info? I do not want to wait until everyone is registered and then perform a sort function. I would rater contestants fall into a place as registration is ongoing. Thanks in advance!
6 Replies
Specifically, I'm looking for Column B on the "Contestant" Sheet. TIA
Hi Holly,
Did I understand correctly numbers in B shall follow the dates in D? Later the date - lower the number. If so, what if there are several records with the same date in D?
And shall the numbers in B be sequential (starting from 1 the for latest date) or here is another numbering?
If like above that could be
=IFNA(RANK.EQ($D3,$D:$D,0)+COUNTIF($D3:D$4,$D3)-1,)
in D3 and drag it down. Attached.
Not exactly. The DOB is only used to determine Age Group value. Once I have the age groups assigned, I need to start with the last person who registered in the youngest group (from column A) and assign them the contestant #1, followed by reverse order of registration for that particular group. Then, the next group will follow the same process, but will start with the next number not used by the first group. For example, if I have 5 people in the first group, I will need to start with #6 on the second group. I have the possibility of 11 age groups that need to be done in consecutive contestant numbers from 1 to the total number of contestants. Does that make sense?
