female

  1. E

    Change Coulour if gender is female

    Hi would appreciate any assistance here. I have a cell in sheet Fig 2 that has multiple names. this cell brings names based on a macro from Master_Data sheet. I would like to be able to know who is male and who is female. In Master_Data I have a column which specifies female or male, Column D...
  2. kelly mort

    Speak with female voice - VBA text to speech code

    Hi there, I want the voice recorded in a female voice. Can someone fix this for me? I found this on Wikipedia Thanks Sub TestStringToWavFile() Dim sP$, sFN$, sStr$, sFP$ sP = ThisWorkbook.Path & "\work\" sFN = "Mytest.mp3" sFP = sP & sFN sStr = "I want you to speak...
  3. J

    Averaging when certain criteria in another column is met.

    Hi MrExcel group :) To the sheet below, I would like to add another set of stats to separate average days at fledge for males and for females (without trimming the mean). Male and female designations are in the name column. I should be able to do it as is without making a separate column for...
  4. 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"...
  5. P

    Age Group and Gender

    Hi, I am having trouble sorting out this data, I need to sort it out according to the table and the value in the table should be counted as number "1". In the first row, the column 4&5 was supposed to be merged but I can't do it here:confused: same with 6&7, 8&9.:biggrin: <tbody> DATA DATA DATA...
  6. G

    Excel vba to select item from dropdown on webpage

    I'm having trouble getting the syntax right to select an item from a dropdown on a webpage. It's to select gender. I think it's something to do with it using javascript. When I do Inspect element on the dropdown I get the following: <table width="100%" style="z-index: auto;" cellspacing="0"...
  7. G

    Text to column but in rows

    Hi All, First time on this forum and was hoping to get some help. I am trying to do a text to column but in vertical format instead of having it split horizontally. For example, My data now looks something like this. <tbody> Name Attributes Tom Male, Teen, Tall, Glasses, Black hair Henry...
  8. L

    Charting

    So I have this spreadsheet that polled people as to what activities they would like to do. How do I make a pie chart about that shows the percentages of those who said "yes" to each individual thing? <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col...
  9. M

    Conditional Formatting

    Hello Everyone, I am trying to use Conditional Formatting... Our goal is to have clients with viral load results less than 200, When a client's viral load lab result is greater than 200, there should be an X in front of the lab results (see below) When a client's viral load lab result is...
  10. K

    How to find extract information from a table

    Hi all, Hopefully someone can help me :) I'm trying to extract information from a table. If I insert the Employee ID, it should provide the Name and Email in separate cell. Insert Employee ID here > [ ] , result > [Name], [Email] <tbody> Employee ID Name Gender Email Contact 120391 Chao...
  11. proficient

    Help with if condition

    Hi all, I have a column having digits like below; If the last number of cell is even I want female in very next cell else male 4220173438421 4220196875982 4220173485269 4220165478638
  12. B

    Filling in cells based on value inserted on one previous cell

    I am going to try and explain this the best way I can because I cannot seem to figure this out. I have made two seperate tables on a different sheet, one table for score standards for female and the other table for score standards for males to use with VLOOKUP. I want cell A1 to be a dropbox...
  13. B

    Input data based on criteria

    I have a sheet that I need to complete. I need to enter data where cells would popluate value based on criteria. Example: Criteria is male or female in cell A1 The follwing cells next to it would be based on male or female standards. If its a male, they did 40 pushups then they get a perfect...
  14. B

    Inputing data based on criteria

    I have a sheet that I need to complete. I need to enter data where cells would popluate value based on criteria. Example: Criteria is male or female in cell A1 The follwing cells next to it would be based on male or female standards. If its a male, they did 40 pushups then they get a perfect...
  15. K

    ELL Classes

    I have a spreadsheet in excel 2016 that contains the names of all the students in my school. The sheet has the students’ names, student id (which is unique for each student). One of the columns in the spreadsheet is ELL (Column I) which refers to English Language Learner. If there is a “Yes” in...
  16. S

    Excel function to use

    i have two columns -marital status & sex. i want to access a person to be married and is a female. which excel function do i use to determine whether a person is married/single and is a male or female in each of the categories? thanks for any support.
  17. A

    Working with Quartiles

    Good Morning all. I am trying to find out if it is possible to work with data in quartiles. So, if I had a list of salary data attached to Male and Female employees I know I can find out what each of the Quartiles are, but is there a way to say in the top quartile there are 55% Male and 45%...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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 MrExcel.com.
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 "mrexcel.com".
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
Top