large column data

  1. R

    First Post: Listing variables in a Column

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

    working with Large Non Contiguous Data

    Hello Everyone, Im pretty desperate. I've got a column with around 9000 rows of data and I need to average non-contiguous rows. So I need to average row 1,4,7,10 (every 3rd row or so), and I have no idea how to do it. I just found out that we can use VBA to do this, but I havent figured out a...
  3. C

    Opening data sets in excel that are too large for excel

    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!!!
  4. T

    Finding Text

    So I have a log at work for orders from people in the office that is the format: "Person Who Placed Order"-"Person Ordered For" The account number in the next cell is represented only for the "Person Ordered For" and should correspond to their name. Since there are a large number of orders, it...
  5. PirateJenny

    Large volume text

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

    Hide columns randomly using macro !!

    Hi, I am stuck up in following condition using macro... I have large data in worksheet having 200 Columns and 60 rows in "sheet1". Concept is - User inputs some number where that number's column only be visible and rest 199 columns and their data will be invisible. ( Eg - number entered 2...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top