“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a list of members, their dependents and everyone's date of birth. Each family has 1 unique identifying number. I need to assign the member's date of birth to each dependent under that identifying number (in essence giving the dependent the member's date of birth). The number of dependents will vary per member. I have tried countif vlookup, match, index but am stuck.

Solved by K. Y. in 27 mins

I am trying to use the COUNTIF equation in excel. However, I do not want to count the value in another cell, in the same row, if the values are equal to each other. Can you help?

Solved by T. D. in 27 mins

I'm trying to find a formula to help me with my statistic class. I've used a COUNTIF to calculate how many females are in a class but now I need to find how many females fall within a specific age group and I ca't find the formula I need.

Solved by S. Q. in 19 mins

For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II.
CS302 Midterm Project Part I:
Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II
In your description include the following:
1. Who will use the workbook
2. Describe what the workbook will do (What purpose will it serve?)
3. Describe the type of data that will be stored in the workbook
4. Describe some of the analysis and reporting features of the workbook.
Midterm Project Part II:
Create the workbook to complete your project. Your workbook must implement the following technical requirements.
1. Well formatted with some background color, borders and style
2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field.
3. Apply appropriate named cell references to your workbook.
4. Implement goal seek analysis using absolute cell references and an assumption area.
5. Use conditional formatting on the database sheet.
6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif()
7. Use a database lookup function like VLOOKUP() using a lookup table.
8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet.
9. Create some scenarios and generate a summary report.
10. Add at least one macro with a button to run the macro.
11. Use solver in some way. Be sure to create an answer report.
12. Add appropriate and consistant data validation fields
13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles.
14. Add an imbedded image with a link to a web web site.
15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM".
16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option.
17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade.
Submit your description document and project workbook for grading.

Solved by C. J. in 23 mins

I am trying to automate results of survey results to show what kind of learner someone is. I have a file with the survey answers collated and have used countif formulae to find out which results were most popular for each question. I have also used max function to extract the highest total for each question. I can't figure out which formula to use to relate this number to another set value. Please help!

Solved by I. D. in 26 mins

Thanks for that although I couldn't get it to work, I have copied an example below in which I want to count how many "1" or "1a" "1b" or "1c" appear in row S - i currently use COUNTIF(marksheet name!S$2:$S251,"1?") but that only counts the cells with a a,b,or c at the end not the whole number cells, hope i'm making sense.
A B C D E F G H I J K L M N O P Q R S
name 1 F 9KN 9A5/En 17/18 BOSCOBEL K Y 92 L 3 8.85 2.8 1A 1 1
name 2 M 9AP 9A3/En 17/18 ATTINGHAM N Y 96 L 4 14.2 4.7 3A 3 2C
name 3 M 9FR 9A3/En 17/18 ATTINGHAM N Y 96 M 5 16.9 5.6 4A 4 2C
name 4 F 9FR 9B4/En 17/18 ATTINGHAM N Y Y 100 L 4 14.6 4.9 3A 3 1B

Solved by V. L. in 14 mins

Having trouble with the formula =IF(AND(COUNTIF(G17:J17,">0")>=2,(M$17=C$8)),"Excellent",IF(OR(COUNTIF(G17:J17,">0")>0),(M$17>=C$7)),"Good","Poor"), please help

Solved by I. H. in 24 mins

I have a column of data with nonunique values in it. I want to count the number of times within the column that each value appears. I have a second column with only the unique values present, as a means of referencing individual values. How can I format the COUNTIF function to keep the range for the column static, while having the characteristic increasing reference for the unique value (which the function is counting) increase?

Solved by K. S. in 25 mins

ESCRIPTION:
I have a .csv product file and one column has pricing data and the column next to it is empty. I need to fill in the data that matches the pricing column. For example if one of the box is 22.99 I need the empty colum box on same row to be certain number. And if another box is same price then same number gets filled. But if it's different number different number is filled and so forth. 1. Do you see column P (Header is Variant Price) 2. Next to the column on the left is column O (Header is Variant grams) (So you can see that it's filled with 136 right) 3. I have to basically fill the column O (variant grams) that corresponds to number range 4. So let's say if column P has number range from 1-8.99 I need the corresponding column on left (O Variant grams) to be a certain number. So same row, and so forth 5. Column O is prefilled with 136 and the following range will be used to fill in the Column O boxes and delete 136 (if it's 136 then just it will not delete it) range 0 - 7.99 = 136 grams (word gram will be omitted just need it to be a number) 7.99 - 14.95 = 226 14.96 - 26.95 = 317 26.96 - 35.95 = 431 35.96-53.95 = 1360 53.96 - 64.95 = 2276 64.96 - 74.95 = 2948 74.96 - 1000 = 3175 These are temporarily ranges, but as my shop prices and shipping weight changes, I'm hoping the formula or vba can be easily changed by me SO UPDATE... I did a session and got this formula =IF(P444<14.95,226, IF(P444<26.95, 317, IF(P444<35.95, 431, IF(P444<53.95, 1360, IF(P444<64.95, 2276, IF(P444<74.95, 2948, IF(P444<1000, 3175, 0))))))) But this was wrong so need the correct one.
So this is the formula I got for the second time
=INDEX(Sheet1!$D$2:$D$9,COUNTIF(Sheet1!$C$2:$C$9,"<="&$P2)+1) and is accurate but not sure how to apply to the whole column.. same number shows up

Solved by X. W. in 30 mins

I am trying to count 200 different unique values across a spreadsheet of roughly 200 columns and 5000 rows. Countif only works for single columns, I need a formula to count across an entire sheet.

Solved by F. S. in 28 mins