missing values

Hello! I am new to excel and have learned a lot from these messages boards and hope to keep the learning momentum going. I have a large dataset with over 25k rows and hundreds of columns. I would like to delete rows (participants) who have over 50% missing values per variables. Each column...

Here is picture of needed data. There is a piece of data (table 1). Primary data starts with March 2010 and I filtered it by Employee 1 and Employee 100. As you can see Employee 1 was not at the Project in May and December, so in May Total Expenses change was -$700. One part of my task is to...

Hi everyone, i'm very new to access and am learning how to use tables. for my current project, my goal is to create a database of employees with their info, and I want it so if I upload an excel document, it automatically adds it to the database and updates the db. however, the issue is that in...

Hello, First, all of you have been a huge help over the years. This is my first time posting, so I hope this is not incorrect in any manner. I appreciate any assistance. I am creating a VBA automation step for peers that have to manually enter in contract information for each of our...

I have 8 worksheets in the same workbook. Column 2 in each worksheet has the employee's name. Column 3 has the employee's commission. Since not all employees remain with the company. I need the equation to look for the employee's name in Column 2. If the name is found, add the commission in the...

Hello I am one f those people that can normally solve an excel problem with a search. Unfortunately, I can't find what I am looking for this time. Please help :o) Here is my problem, I need to be able to create an average total that skips any missing information. For example, if I have four...

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in...