I am building a weight loss tracker for a contest. I want to rank both the Male team and Female team by total weight lost each week.
What I need to know how to do is in Column U I have a rank formula. What I need it to do is look at columns C and D and determine if the person is male or female and run two different ranks.
For Example if there are 10 people 5 male and 5 female, the rank formula in column U needs to rank just males (column C) 1-5 and then just females (column D) 1-5.
The spreadsheet is attached for reference.
Bookmarks