help a student

hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...

Hello I am new in Excel and I would thank a lot if someone can help me. I wrote this code with linked dropdown lists in cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$S$4" Then Range("$T$4").Value = Empty End If If Target.Address = "$S$5" Then...

Hi. Can I get all the specific information I need in one master file? Here's a vague explanation of what I want to do. File 1 Name Fruit Country Phone Color James Rick Apple Korea 555 555 5555 Red Terry Williams Grapes Malaysia 444 444 4444 Blue Steph Curry Melon Philippines 333 333...

Hello all, looking for a solution to my VBA problem, I came across this forum via the internet and immediately created a profile as this seems to be a very active and friendly community. My problem is the following: I would like to create an overview Excel file that allows me to define...

Hi, I am very new to Excel and still learning the ropes. I have the following table where I have Account Name and Assigned Staff. The reason there are duplicate rows is because I am pulling in data based on trade dates. My goal is to remove all the duplicate rows and be left with unique...

Hi there, I have been set a task in excel but I have no idea how to approach it, my mind has gone blank. The dataset is fairly large. It asks that I ... Please combine the data on the two tabs, noting your steps to explain later. Add a column of total score per respondent and grade per...

Hello everyone! I have a question about the "track changes" feature in Excel. The function itself works great for me! but when I save the workbook the History sheet keeps disappears and Excel loses the history file that I just asked it to keep. How can i prevent it for disappearing? i want...

Hi everyone! first of all thank you all for taking time to help me with my minor problem I am currently intern employee in a big Oil & gas company. They are seeking for a excel document that can track changes when different employee's edits the worksheet. I have already inserted a VBA code...

Hi all, I have the following formula: It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today. However, I am also referring to cell C7 in another cell, specifically like this: My issue is, obviously, that the cell...

Hi, I am trying to create a formula in excel which shows the provides the Cumulative distribution function for a skewed normal distribution giving set parameters for skewness, mean and std. dev. I have done this for a normal distribution using the Norm.Dist (Culminative True) function, but i...

Hi . I have managed to put in a vba code for my task , learning from here and there. what it does is. 1.when I click on a cell on a sheet 1 it copies the whole cell row on sheet 2. 2. It renames sheet 2 dynamically with info ( copied row from sheet 1 and used row on sheet 2 ) which is very...

Any help would be tremendously appreciated. I am on hour 2 of trying to figure this out. An example: Tab 1: Job # Job Revenue Job Cost Job Status Job Mat Spend 23 100 80 Closed 20 42 200 150 Active 10 56 100 90 Active 30 71 150 30 Active 40 83 100 85 Active 40 I have around...

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

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?

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.

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

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

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

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