I've got a sheet of about 500 entries. This sheet contains 4-letter words in one column, a corresponding number to this row, and a corresponding gender. I need to make a function that finds all rows with the same 4-letter word, then gets a number for males, as well as a number for females. These numbers will then be calculated to an average for males, and a average for females.
Any suggestions? :)
Doesn't have to be one formula for both genders; it can (actually would prefer it to be) one formula for each gender.