dataset

I have got a very large dataset on which I need to perform some data analysis. There are roughly 100 variables but there are multiple iterations so in the end it is closer to 15,000 variables. I need a way to select just the variables with the same header in a new worksheet as that will make it...

I am working with a huge data set and was wondering would a dcountif work if I need a column which has random loan numbers in it give me back the count of how many times it is in the column. Their might be four or two or 1. I have another formula counting if there is a 1 to give me one answer...

Hey guys, so I have a pivot that looks something like this: Name | Class | Apples | Oranges | Pears | Cranberries ----|-----|------|-------|-----|----------- Andy | 2015 | 1 | 2 | 3 | 4 Bill | 2015 | 2 | 3 | 2 | 2 Bobby | 2015 | 1 | 3 | 3 | 3 Chester | 2015 | 3 | 1 | 2 | 4 Gerard | 2014 | 2 |...

Hello everyone, this is my first post here. I am using Excel 2013 on Windows 8.1. I have posted my issues on Reddit before, without results unfortunately. I am currently manipulating a very large dataset (500k rows approximatly) that I need to reorder before analyzing the data. This picture...

I am creating a very large dataset (50-60 thousand unique entries), and I am currently in the process of writing a formula that will fill certain sections automatically, given certain inputs. The autofill would be dependent on 2 variables (V1 and V2), such that I would want the formula to...

Hello, I'm currently building a very large database, in which two of the columns contain the same information, but in different forms. One column gives the name of given country in the set (eg Afghanistan) and the other column gives the abbreviation of that name (eg AFG). I am trying to set...

Hi folks, I was hoping some of you geniuses could help me with this problem. Ultimately I need to mail merge data based on a data source being fed into Excel ideally without using Macros as I know nothing about them. My Dataset looks as follows - Code,Title,First...

Hello, I am relatively new to the repertoire of functions in Excel and need your suggestions. Anything will help! I need to build this set as soon as possible. Project: Building a dataset based on US Imports. Every product has a unique identifyer (product code). If a product qualifies for...

Hi there, I have this dataset column A, B and C. In column B are Batch Number (e.g. 26848), Fund number (e.g. 400), and activity Codes, (e.g. 2ACQCOLD01). The idea is to create a code when column B has an activity code. For example 26848 is the Batch number, then 400 is the fund number, now...

Hi all, Hope someone can help :) I have sales figures for 2 different years. They are laid out as so; 2011 Sales <tbody> Country Volume Product Code UK 1000 100123 USA 245 100123 Germany 566 100124 Germany 201 100125 </tbody> This table is repeated for the next year, however there...

Excel 2007 user. I have a spreadsheet with over 1000 lines of data, that is spearated into 30 different subtotal groups. I tried to eliminate the subtotal lines and revert back to the original dataset. I started clicking the small box in the upper left corner to select the entire dataset. Then...

I have 4 columns of data with field names/column headers (people, office, case number, date). I have over 60,000 rows of data within those 4 columns. A single case number can have multiple people work on it over a given period of time in different offices (ex: John worked on case number 3 during...