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