Fill cell with value, based on criteria of other cells

Hi Grantsmith,

Are you able to create a spreadsheet and manually enter in the intended results? I, unfortunately, do not quite understand what you are asking for.

Hi Grant,

To protect users security and integrity could you do this:

please attach the file here, as some members can't or won't access file-sharing sites.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Weird? It's a dropbox link.

In any case, as requested

Just to confirm that I have this right,

you wish to:

Auto populate a cell based on multiple conditions such as gender restriction, age group restriction and find the person with the highest score within that?

That sounds right yes. These will be race results. So there overall time ends up in col J. So I am looking for the winner of each category. Categories being:

Overall Male
Overall Female
U18 First age group male
U18 First age group female
18 - 39 First age group male
18 - 39 First age group female
40 - 49 First age group male
40 - 49 First age group female
50 - 59 First age group male
50 - 59 First age group female
60+ First age group male
60+ First age group female

Hi Grantsmith,

could you tell me if the manual data you entered was just random or are they suppose to be the overall female or male, I can't understand why they are when my formula is bring back different people, thanks

In the example I gave, Overall male is race number 12, his name is Andrew George, he is male, and he won overall. So his Overall position is 1 and his gender position is 1 along with Age group position. Same is true with Barb Morris, however, she is Female.

Hi Grant,

In the data you have provided, Andrew George's overall position is 36, gender position is 6 and age position is 3 and barb is 45 3 1, so my question still remains, are these randomly chosen irrespective of the data or are these the actual overall winners