missing data

I'm writing up a note on #N/A for my students (adult office workers). I condensed the answers to students' questions into 5 paragraphs. I would appreciate any comments about mistakes or potential logical problems. Much thanks, John. #N/A – An IntroductionA display of #N/A means not available...

Hi there, I'm currently trying to plot two different data sets on the same line graph. The x-axis is time for both, however, the time is spaced at different intervals for each. (i.e. one records a point every 15 seconds, and the other records a point every 20 sec). My attempt at combining...

Hello, I'm using Excel 2010 and I have an issue with a Pivot table. I'm creating a pivot table from a named range called "Range_LgLossTriangle" but only 10% of the data are shown in my pivot table, if I hit Change Data Source and put the address of the named range instead of the name of the...

I have a spreadsheet where the far left column is a list of names and the columns to the right have information about the person listed in each row on the left. Column B has phone numbers and column C has email addresses. I only want to include the value in Column C (email) for people who do not...

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

I have two column with almost same data. However, a few IDs are missing in one column. Here is my example: Column A-Column B 3.1.1-3.1.1 3.1.2-3.1.2 4.1.1-4.1.1 4.1.2-4.1.3 4.1.3-5.1.1 5.1.1-5.1.2 5.1.2-5.1.4 5.1.3-5.1.5 5.1.4- 5.1.5- I know it is easy to tell that in Col B, 4.1.2 and 5.1.3...

Hi all, Excel appears to be deleting cell values when I save my workbook and reopen it. The cell values that are being deleted are on 2 sheets and are being removed from both. I am simply lost to why this is occurring. Please help me! Cheers, Owain

I want to show from a set of values that for some values there is a high count and for others a count of zero (result in both tabular and chart form). I make a pivot table with my range of values drug to both the Row Labels and the Values (as Count) and it works for for values where the count...

using software at work to output some data to xl, however it is not very user friendly. when our store list has more than one member name it does not output all the store data associated with that name, only for the first one (it's easier to look at and understand than explain). anyhow is...

Ok so here is the issue. I have a VBA that pulls the information from one sheet and puts it in another sheet on the same workbook. Everything thing works great except for whatever reason it is picky on what it pulls and what it does not. On WorkSheet "Calculator" I have 4 Columns (A:D)...

Hi,</pre>I have a data set in a form of x = [0 3 5 10 32 ... 200000] y = [5 4 3 2 3 ... 4 ] where x represents time (seconds) and y - values for particular time period. I 'd like to add missing data to it. I mean values in between particular time points (e.g from 0s to 5s x =[0 1...

Ok I have looked over several consolidate data posts here but yet to find any that will help solve my consolidate/combine dilemma. SETUP -I have 2 worksheets (Sheet1 & Sheet2) in the same workbook. -Both have the same Column Headers (Columns A through to V). -Sheet1 has about 6K rows of data &...

Hey Hey... Could use some help on this one. I've got some web analytics data that is flawed. There are basically three columns IP ADDRESS | CAMPAIGN NAME | USER NAME As you can see from the sample: In Row 2, IP Address 1.2.3.4 came to the site from the Super Ad campaign but did not buy...

Hello I am working with a time series of current speed and direction. The problem is that there are gaps in my data. Example: ID Date Time Direction Speed 1 23/09/2010 12:00 227 74.2 2 23/09/2010 18:00 232 81.1 3 23/09/2010 19:00 229 87.8 4...

I am working on a large document where the user has the option of entering notes in many different cells on the worksheet. I would like a way pull out all the text they enter in a clean way and summarize it. When I say "clean" I mean locate only the cells they entered a note into and summarize...