Help! I am trying to locate a max value within a subdivision of the group (either age group or Division 1 or 2) that would exclude certain other values from being returned as values. It's for a score sheet. Basically, you can only win the highest award you qualify for and are excluded for lower awards in certain areas. I'm attaching the sheet for reference. The highlighted cells are the values I'm looking for, but I know I can manipulate the formula from one to meet the others. Please let me know if this makes sense! Thanks in advance!