I'm making a spreadsheet for work purposes and cannot quite manage to figure out a formula for some of the data they require, the info is as follows:
TAB Name: APPS
Column A: Surname
Column B: Forename
Column C: Sex (M/F)
In a separate tab ('INFO') I need to calculate the most frequently occurring names based on sex. I have managed to work out how to get the mode of the names using =INDEX(APPS!B3:B109,MODE(MATCH(APPS!B3:B109,APPS!B3:B109,0))), but I cannot manage to figure out an equivalent formula which also accounts for the sex column.
Essentially what I have now is a mode of column A and a mode of column B, and what I need is a mode of column A for Males, a mode of column A for females, a mode of column B for males and a mode of column B for females.
Help is much appreciated
TAB Name: APPS
Column A: Surname
Column B: Forename
Column C: Sex (M/F)
In a separate tab ('INFO') I need to calculate the most frequently occurring names based on sex. I have managed to work out how to get the mode of the names using =INDEX(APPS!B3:B109,MODE(MATCH(APPS!B3:B109,APPS!B3:B109,0))), but I cannot manage to figure out an equivalent formula which also accounts for the sex column.
Essentially what I have now is a mode of column A and a mode of column B, and what I need is a mode of column A for Males, a mode of column A for females, a mode of column B for males and a mode of column B for females.
Help is much appreciated
