missing data

Hello all. I am struggling to figure out what is going on. I have a power bi file that is pointing to a folder, that contains over 70 .csv files. Each file is around 200 Mb. I have been working with the power query editor all day. I finally had what I *thought* was a finished product...

Hello, I need a way to identify where dates are missing per ID. If ID002 fills out a survey on 9/6, 9/7, 9/8, 9/9, 9/12, 9/13, I want excel to create blank rows between 9/9 and 9/12 to represent the missing data from 9/10 and 9/11. This spreadsheet will eventually have 300+ IDs filling our...

Hi i have monthly exercises in my work to find the missing data in two sheets (sheet A and sheet B) and categorize them (for example Hotel, Restaurant, Offices) i want to create an Excel file to find the missing data between two sheets and the result should show the missing in each sheet and...

Hi i have monthly exercises in my work to find the missing data in two sheets (sheet A and sheet B) and categorize them (for example Hotel, Restaurant, Offices) i want to create an Excel file to find the missing data between two sheets and the result should be showing the missing in each sheet...

I would like to use excel to predict missing values in a table based on a best fit curve. I suspect non-linear regression analysis is a good way to do this but i am not a statistician and welcome solutions. I have a table of more than 300000 rows but I am posting a small excel sheet with 25 rows...

Hi All, I have a data of 3 years daily exchange rate history. However, some dates (weekends, holidays) with corresponding rates are missing. I would like to fill in missing dates and copy the previous day's rates (for which data is missing) to missing date. So, in the example, the dates...

Hello So, I'm working with a raw data set that I have made, and I frequently update the data whenever I collect data from sources. The first two rows of the data set are frozen, so I can have some semblance of what my data titles are. Using the data, I have made several charts. Now, I know I...

Hi So I would like to work out a 3 month rolling average of data using an OFFSET function. The only issue is how can I amend my formula so that if I miss a month's data the cell is ignored an the previous month's data is used? The formula that I am using is...

I have been given some wonderfully complicated and not at all well formatted Excel spreadsheets at work. These spreadsheets are kept by the nurses I work with and have important patient info in. I'm trying to consolidate the data and then clean it in a hope to make everyone's lives easier. So...

I have several columns of data for which I want to plot x-y charts. The first column is the x, and the other columns will be y for different individual plots. There is missing data in the y columns. Excel treats the missing data as zeros, and plots the points along the x-axis. How to avoid this...

Greets, I am trying to determine the easiest way to find a missing alphanumeric, alpha, or numeric sequence in a excel. I believe the functionality is already there in excel just not sure how to do it or where to start. Any help would be appreciated. Use Case: I am trying to find all the...

Hi Masters, I need the solution for following situation in the Table-01 contains all the details; Table-02 has missing sum data Now in the Table-03, I want the list of missing details given date Range in 'E16 + G16. Thanks In Advance. <tbody> Table-01 Table-02 Table-03 Date...

I have a master list of SKUs in one table set as a column with a different SKU listed in each row. I have another table with a daily snapshot of items which I have in stock between 7/1/17 and 7/31/17 in each row. The table shows the item SKU in one column, the warehouse where there is...

Hi there, I’m having some difficulty figuring out how to plot a lot of graphs at the same time and also how to hide values that are blank. When Googling for help, I found that building a macro may be helpful. But I’ve never done anything like that before so I wanted to reach out to see what...

Hello, I'm a long time lurker, first time poster. I've come across something I can't figure out. I have a table of data, about 7100 rows long, containing data from 30 sampling points that are sampled daily. The table is populated using a macro that appends data from another table. The macro...

I am using Excel 2013. I have a large data field from which I have created a Pivot Table. One of my fields is "Amount". When two rows in the data field exactly match one another, the Pivot Table Rows area only shows one of the rows, but the Values area Sums the two rows for Amount. I would...

Hello, I've found that an advanced filter is likely going to be my easiest option to filter multiple criteria and display the results. The Problem: The filter currently will not show results from data entered by a new user (me). I took over the sheet at row 3166 Data Sheet (some values after...

Hello, I am wondering if there is a way to check a list of columns for a missing close parenthesis, I mean there is an open parenthesis, without a close ou vice versa. Thanks in advance.

I am currently scouring and plugging numbers from years prior into a spreadsheet for graphical purposes and as such have numerous date based cells assigned individualized data. Now, the data points I am pulling from aren't exactly what you would call 'consistent' and miss quite a few days here...

Hi, I have a data connection in Excel 2007 linked with an Access 2007 file. On my computer it works fine but on my colleagues computer it doesn't quite work. When he opens and updates the file, the linked table deletes some data. In the table once it gets past 13/08/2015 it does not produce...