male

Hi, need help with the following. Have a workbook with 1200 lines and 4 columns. Its a list of building material for a office block split by size. For each size there are a number of different products listed. These are then replicated over the 49 floors of the building. Sample below ...

I have been trying to find a solution to my problem, but cant seem to find one. i have a spreadsheet with names in column A, and events in column B and dates in column C. the format of the sheet, is like this Column A Column B Column C <colgroup><col...

I have the following VBA Code Snippet and I've trying to learn how to use the Cells object. How would I replace the Activecell object with the Cells object in the Do Loop? In this instance, the Active cell would be Cells(2,2). What confuses me is how to replace the activecell object with...

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

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

I'm looking for a function that would return a value which has a binary characteristic assigned to it. More specifically, a function that would only return the values with 1 assigned to them (i.e. male employees) into the male employee list but disregard any female (i.e. 0) employees <tbody>...

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

Hi everyone, I'm new to this forum and the world of excel. Appreciate the all the help in advance. Thank you so much! I am stuck with a work problem to automate a recommendation system for matching tutor recommendations to students. (students will choose from a list of recommended tutors)...

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

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

Hi everyone! Looking for some help if possible. I have cell G4 that needs to read data from one of two sheets, depending on the data that is entered for cell D4 (either male or female). The next two cells, E4 (age) and F4 (number of repititions performed) will be manually entered to get the...

Hi All, I need to amalgamate some data I've got but my minds gone completely blank. The name is all one person but I need all the types to come into one Cell. I'd normally use concatenate but some people haven't had all the tests so the data isn't consistent. Some have only had 2 parts..I...

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

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

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

This is the formula I have now: =Sumifs(p2:p10,g2 :g10,"x",f2:f10, "male") How do I add only positive values in p2:p10? Thanks in advance Kelly

Hey folks, Having an issue with our Excel data collection and hoping for help. I run data collection for national survey we are conducting for our organization. For years we have used an Excel spreadsheet to catalog the demographic information of our members and have used drop down boxes for...

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

Hi All. I need to create a chart that shows the differences in attitude to 5 statements amongst 2 different audiences all on the same chart. Assuming we are going to use a stacked bar. 1) There are 2 different audiences Male & Female so they need to show in the labels on the left. 2) There are...