1. K

    Return "Gender" Value From a "First Name/Gender" Reference Table

    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...
  2. G

    Data into age buckets

    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...
  3. W

    Average age by gender

    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
  4. P

    Auto-Populate Columns Based on Cell-Lookup Result?

    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...
  5. R

    Merging Columns, Need help on the Right Equation

    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...
  6. E

    Error with Median formula

    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...
  7. T

    Ordering data by highest number and gender per same number

    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"...
  8. I

    Is it possible to name filtered criteria in Advanced Filter?

    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...
  9. M

    Calculating text values with owner ID numbers

    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...
  10. A

    Class Generator

    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...
  11. B

    Need help with this complex problem

    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...
  12. A

    Is this possible?

    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...
  13. B

    If, and and vlookup statements in one formula

    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...
  14. M

    Dropdown sometimes other times auto value

    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...
  15. C

    Sumproduct mystery

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back