Excel VBA - I have this worksheet that have contestant name, gender and racing time. so for eg I have:
Name | Gender | Time | Overall | MaleRank | FemaleRank
Mitch | Male | 15.06
Jess | Female | 16.06
Rach | Female | 17.07
Will | Male | 17.09
and so on...
I want the system to be able to identify the overall(Both male and female) 1st, 2nd and 3rd places under the Overall column, I also want it to be able to identify the Female 1st, 2nd and 3rd places and identify them under FemaleRank column. So same for Male1st, 2nd and 3rd and identify them under MaleRank. All of the ranks need to be calculate with a button click in excel vba forms. So after I clicked the button, the above example will display:
Name | Gender | Time | Overall | MaleRank | FemaleRank
Mitch | Male__ | 15.06 | 1st___| 1st Male _|
Jessy | Female |16.06 | 2nd___|_________| 1st Female
Rache | Female |17.07|_______|_________| 2nd Female
Wille | Male__ | 17.09 | 3rd____| 2nd Male |
and so on...
p.s the time will first be sorted in ascending order and pls ignore the __'s as they are use to make the columns look more understandable. Actually any kind of way to identify the 1st, 2nd and 3rd places is fine but this is the only way I can think of(by making 3 new columns)...
I don't know how to do it, can anyone give me a hint? Thanks.
Bookmarks