large data

Hi, I have a large data ranging between 200k-400k row every weekday to analyze. I need to get result for Column P, Q, R, S, T, U , V, W, X, Y from Row 2 to Row 7201 (sometimes until Row 1441 , 481 ,241 ,121 depend on what kind of analyze is). Current formula I use is "...

Hello, Using 2010 Excel, I have 192k rows and 6.5m filled cells of data that I need to be able to match certain criteria to and pull the matching rows from the data sheet into another sheet. It also needs to be as fast as possible (no looping?). My research took me to these posts regarding...

Dear Experts, I have a large array I need to dump to a range. I read that there are limits on the size of array you can dump, so I wrote this sub to prevent writing too much to the sheet at once. I still get an error when writing row 1385, column 11. This item of data is a string that is...

Hi I'm having a helluva time with excel since I remove duplicates from 33k row of entries from column A to P Now I came across an issue, I need to merge multiple address in a single file row how ever each entry have multiple name, I need help in removing those multiple names after merging...

I've got a code that searches a loads database, takes the numbers and puts them into a calculator, gets a number from the calculator and then adds that factored load to another database. To perform each of the major steps in my code, I call a function. Now when I call each function in order...

Hi All, I've been tasked with creating a Power Pivot spreadsheet for my boss to summarize data, from a MS SQL server DB, at the end of each month. However, PowerPivot doesn't seem to be able to handle the amount of data I need it to handle, and suggests upgrading to 64 bit excel or upgrading my...

Hi, I have a list with the following names: Location | Date | Count of clients (only fron that date) | Employee I created a Pivot table to show me how many clients we received a day for the locations (Easy) Location Names <- Dates -> |...

Hi, I have a large data set, ~200,000 rows, 12 columns (for context, columns from left read: student name, school, teacher, exam, result etc..). With as few formulas as possible, how do I select individual data points about different people from within this data set that are not directly next...

Hello Everyone, From what I thought would be a straight forward function, this has had me scratching my head far too often this week. Until now, I've been manually sorting and copy/pasting in data, but this enhances the possibilities for errors. I've been trying to use a vlookup and index/match...

Hello, I have a very large database that contains names with minor differences on column A such as: A EXCEL AMERICAN COMPANY S.A. EXCEL AMERICAN COMPANY SA. EXCEL AMERICAN COMPANY, S.A. ASSOCIATION, INDUSTRIAL ASSOCIATION INDUSTRIAL L.A. COMPANY CO LA COMPANY CO As you can see, this makes a...

Hello Everyone, I have few datasets containing millions of records. Is there any program that can be used for the purpose of handling and managing such large datasets? Kindly note that each dataset is contained in one table. ATM, I am using Excel, but the problem is that I have to split the...

hi guys So im working on large data sets with about 2000 entries. i want to be able to 'decompose' the multiple entry fields so that they fall in the right places ( with 1 count for 1 unique name) an example my spreadsheet Name Location for holiday David...

Dear All, I have developed some algorithms for organizing and analyzing a large dataset of Excel files (2GB). Each algorithm is included in multiple modules, and hence they are very long to display here. When I try the codes with small datasets (few Excel files, 10 for example), it works with...

I found a way to get sumifs to work for my spreadsheet. My question is whether there is a better way or a faster way to do this. My sheet has 100k+ rows, there are 6 columns this formula checks against for a certain part, once it is found it checks month or date(depending on sheet) and adds...

Hi there, I have this Dataset - <TBODY> 170</SPAN> Batch No: 170 Period: 12/13/01/01</SPAN> 170</SPAN> 170</SPAN> 26/04/2012</SPAN> 400</SPAN> Narrative of Jnl </SPAN> BC01</SPAN> D001</SPAN> 3MM12 </SPAN> -250</SPAN> 170</SPAN> ---------------</SPAN>...

Hello Everyone. Could you please help me with one question, because I am already struggling for a few hours. I want to plot large number of lines, which consist of two dots each, where each dot has (x,y) coordinates. I also want them to be plotted in exact the same style (e.g. color, marks and...