# help a student

1. ### Average

Hi , i have a question . How do i find the average for each row? Do i use the =average(number) as in picture 1 and then click on plus or =average(number:number) as in picture 2 and click on plus? I need the data to be in average to run the regression . My professor said that we need to find the...
2. ### How to answer this question

Find out if there is significant differences of buying beauty and hygiene products based on gender? What do i need to do in order to answer this question?
3. ### Formating cell

Hi, is it possible to format a certain cell as blank? For example , I want the Somewhat Agree to become blank when i use the COUNTA function.
4. ### I need help finding a SQ FT Formula

Is there anyone out there that has found a basic SQ FT calculating formula, Ive read into some forums and I've came across this formula, =LEFT(D19,FIND("'",D19)-1)*SUBSTITUTE(RIGHT(D19,LEN(D19)-FIND("x ",D19)-1),"'","") , Im currently having to go into the formula and changing the cell It will...
5. ### Need a quick assistance for a Gantt Chart in Excel

Hello, After I enter a date range (start date and end date) for a certain task, I want to be able to physically enter each day a value; say 0 for not done and it would show it in red color, and 1 for done and it would show it green color. Also when I put either values 1 or 0, I want the data...
6. ### Help

Hello everyone! I am currently studying accounting as an undergrad, but I want to pursue a career doing AIS (Accounting Information System). What coding language do I need to learn before I get into the AIS field? Any advice on the matter would be appreciated!!
7. ### Time Value Distribution Automated?

Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...
8. ### Need help with either Conditional formula or VBA script to solve issue

Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution: Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be...
9. ### VLOOKUP and return complete row but with certain conditions

Hi, I am new to the forums and I need some help please I have several rows where a specific Event ID (Column A) occurs multiple times. What I want to do is have all the key information on just 1 row without having the Event ID being displayed on multiple rows. As shown in the attached image...

Excel Solver question: The University of Western Football Team has hired a dietician from a big name American school to develop a nutritious lunch menu for the team. After consulting with Canada’s Food Guide and other sources, the dietician has determined that each lunch serving should have...
11. ### Array formula for unique dates for specific names

Hello, I am trying to count the number of unique dates between 1/1/2018 and 12/31/2019 for specific Well names. For example, Well Name (29-6 64N) has 5 rows of dates in which 4 of those are unique and the other is repeated. Is there a way to count how many dates are unique for each Well Name...
12. ### Need help with creating all the possible combinations from the table.

after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...
13. ### Help a student

Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...

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

### Which adblocker are you using?

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

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