gender

Hi everyone, I am having troubles with something in Excel. I have a list of thousands of people (some with similar first and last names of course) and I have a gender column that I would like to fill out based on another table in the same worksheet that I made (see attachment name "Main...

I have a large list with one columns that have age, gender and race. I need to sort the gender and race into the following age groups: 17 and under 18-64 65-84 85 and older All that comes to mind to me is to do an if statement where I look at the age column and say, for instance, if it...

I am sure there is a simple answer to this question. I need to find the average age of people by their gender. I have used this formula and each time just get #NUM ! =AVERAGEIF(B2:B696,"F",C2:C696) Any help gratefully received

STARTING POINT: <tbody> Name Beginning Change #1 Change #2 Change #3 Ending Bob Sarah </tbody> Data will be manually populated into the "Name" column above. After populating into the name column, my goal is to have the subsequent columns automatically populated based on whether...

Hi Everyone, I am having trouble with an excel project in which I have two columns that I feel could be merged into one. I have designed a database that keeps track of adjectives used to describe dog toys by men and women. I first track the gender of the dog, then the gender of the toy is the...

Hi all, I have a formula that pull back the median from a list of values: =MEDIAN(IF('Median Gender Pay Gap'!N:N='Median Analysis'!G$4,'Median Gender Pay Gap'!AI:AI)) In order for to work I need to add the brackets back in: (like below) {=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median...

I am trying to create a formula that allows a set of data to be interrogated and then extract and display in set pattern. The data set will cover thousands of rows, for simplicity I have cut this to 15 with three columns <colgroup><col width="64" style="width:48pt"> <col width="76"...

If you have a table of data, say: <tbody> Name Age Gender John Smith 45 Male Jane Smith 44 Female </tbody> To which you apply an advanced filter which returns cells with ‘Male’ in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which...

Hi everyone, I'm stumped on tidying up a situation and am hoping for help. This is related to a research project of mine. My database is tracking items owned by men and women. I used to enter the gender of an owner in Column C once per unique user, and then in Column D entered the user's...

Hi All - I am looking for some help with a problem for work (assistant principal). What I would like to have done is to take the following information (Student Name, Behavior, Academics, Gender) and then generate a certain number of class lists that represent approximately equal distribution...

So i am creating a spreadsheet and I need help a conversion that I need. I am looking to have a number that falls within a range of numbers, be converted into a numeric value in a different cell. The catch is that the range of numbers is decided by gender and age. For example: A1 is gender A2...

Hi all, I have the following sheet: <tbody> A B C D E F G H I 1 Name Gender Level 1 Level 2 Level 3 Level 4 Level 4 Level 5 2 John M A* B A A F C 3 Ali M A C B D E C 4 Mike M B D A* C A A 5 Pauline F C E A B A* A 6 Harris M D F D A* B A* 7 Nasima F B G G E C B 8 Luba F...

Hi Folks,I need a formula for the following. Cell B127: Persons Gender (Male Female) Cell B128: Age (Persons age Cell: I192: Returns the average grip strength of the person I am doing a grip strength assessment where by cell I192 returns the average grip strength over three attempts of the...

Hi all I'm hoping someone can help. Look all over for a solution but no look. Now I'm pretty proficient with Excel and not bad at VBA (still refreshing my skills) bit I'm stuck! Let me try to explain. I want a cell to autopopulate with M or F for gender if the group looks like this 10CS-B or...

Hello all, I'm a bit stumped, hopefully someone can help me out. On a prior project I used =SUMPRODUCT((O253:O543="x")*(R253:X543="x")) to return the number of minority males O253:o543 had an "x" if the person was male and R253:x543 had an "x" in one of the column if the person was a...