large data volume

Hello all, I have a MacBook Pro that is 3 years old that has undergone some physical damage (a few drops). A few months ago, I was working on two Excel worksheets (one had >850 rows and 3 columns and one had >12000 rows and 24 columns) and a Word document (around 60 pages long)...

Hi, I apologize if my title did not accurately represent my problem, but the image below illustrates my issue: imgur: the simple image sharer Basically, I am working with a large set of study data, and I need to pare it all down to a single row per study entry. As you can see in the image...

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

Hey All, new to MrExcel so please be kind, I fear my question may be viewed as simple by some. I have a datasheet with 6000+ entries. One column has lists of companies, of which there are around 300 and their are entered into this column multiple times. I organized and identified the largest...

Hi - using Excel for Mac and have a large volume of data (40k records) - col A is customer name and col B is policy type. To count how many customers have (say) 3 policies I was previously told to use: To count how many customers have three policies...

Hi - new to this but thanks to all for help (Excel for Mac 2011). Have searched and can find lots to help but the size of my data means am crashing by usual methods of sorting - I need a formula for this rather than pivot tables. I have a list of c. 40,000 rows. Col A is client name (largely...

Excel 2007 Windows XP Hello! I currently have a set of data for the activities of agents for up to 6 weeks of dates. Right now each activity is on its own row. I would like to have only one row for each agent for each date and combine all the activities in on cell with a break after each...

hi, I have a large amount of data (168035 * 374) which i want to process. My task is to search some specific record on user input. e.g., If user is asked to input some number. Then this number will be matched with all A1 (168035 rows)and if the match occurs in multiple places, it should fetch...

Hey Guys!!:) I've got a dataset that is too large for excel, (a few million rows when the limit is 1048576) To overcome this I've been copy and pasting within this limit which is time consuming, is there any way to automatically paste excess data into the next column? Thanks in advance!!!

I have a large data set with many complex formulas, and I started running out of resources getting errors. I've created a VBA procedure that will import a new data file, set up the appropriate formatting, named ranges, etc. The rest of the spreadsheet updates automatically using many VLOOKUP...

Hi, all! I have a large sheet with, after a boatload of formulae, a TRUE or FALSE returned in column AZ. I thought I was finished, but apparently there cannot be two TRUEs with the same value in column D. I need a formula to keep the FIRST true event true, and change all the duplicates to...

Ok, so this has probably been posted before, but I can't find it on any google searches because I'm not entirely sure what you would call it... I need the end user to see a chart of at least 400,000 values (1000x400) simultaneously (and potentially 4M :eek:). This has perplexed me for quite...

I am a research assistant extracting data from Word documents and copying it to an Excel sheet. Some of the data is lengthy and (for the purposes of the research) cannot be broken into multiple cells. At a certain row height (242.25) or character volume the text will no longer wrap. I have...

Hello, I have made a spreadsheet which people will use to look up cancelled bookings made with one airline through lots of different travel agents. The users will type in the (normally but not always unique) booking reference, and will get a small table of information about that booking, which...

I have a bit of a tricky problem. Hopefully someone can help me because this one has me a little stumped. I'm pretty new to Access and VBA for Access is not the same animal I know from other Office apps. After exporting to Excel and running a module to remove the unnecessary data (which I...