Hi everyone,
A tough one...
I have names in Column A
I have ages in Column B
I have gender in Column C
I have totals in Column D
Column E is where I want the desired data of the MAX function to show

I want Column E to find the MAX of Column D based on the conditions that Column B="8" and Column C="F". I then want the Column E to display the data of Column A, based on the MAX.

Example of the spreadsheet (Column E shows what I would like to search for):
Capture.PNG